if you open a blank workbook in excell 2007
the workbook is in compatibility mode
save your workbook in *.XLSX format
close your workbook, and open again
ta da
On Mon, Mar 7, 2011 at 5:36 PM, dpk wrote:
> how to increse rows in excel 2007 from 65 k to more
>
>
--
-
I got the solution. I am using Excel 2007 and it is in File-Excel
options-formulas, under formulas there is an option R1C1 which was tick
marked, I removed that and now it is showing column header as A B C D in
all excel files.
with regards,
Usha
On Tue, Mar 15, 2011 at 12:10 PM, Usha Gusain
Dear All,
In Excel file, we get column name like A B C D. but in my excel file it is
showing numbers 1 2 3 4 how can we change it?
Regards,
Usha Negi
--
--
Some important links for excel users:
1. Follow us on TWIT
"Technically" if your Excel 2007 Default Save format is "Excel97-2003" format,
then what you said is true: a new workbook opens in "compatibility mode".
If your default format is .xlsx, .xlsm, or .xlsb
then a new workbook will have 1,048,576 rows and 16,384 columns
(even before saving!)
Paul
Dear Experts
i have list of reapted name. and i want a list which have name only one time
if any new name add in list then it will add name.
example
List of Repeated name:
A
B
H
E
A
H
A
H
I
A
B
I
List should be this type:
A
B
H
E
I
thanking you
--
<><><><><><><><><><><><><><><><><><><><
Its not working at all,
Pranab
On Tue, Mar 15, 2011 at 5:56 PM, Paul Schreiner wrote:
> "Technically" if your Excel 2007 Default Save format is "Excel97-2003"
> format,
> then what you said is true: a new workbook opens in "compatibility mode".
>
> If your default format is .xlsx, .xlsm, or .xls
"it" is not working...
Excel?
your computer?
What did you do?
What happened/didn't happen when you did it?
Did you:
Open a new workbook?
Does the window title say that it opened in "compatibility mode"?
How many rows are in a new workbook?
Paul
From: b.pranab
Too many questions, not enough answers.
What version of excel are you using?
Do you want the duplicate names deleted from THIS list,
or do you want the unique names listed elsewhere?
When a name is "added" to the list, are you wanting the name to be
"automatically" added to the unique list
if
HI Paul
I am using Excel 2007
Yes i want added a new name to the list, which will effect
"automatically" added to the unique list if it isn't already there.
i am not to sure good in VBA macros.
if it will possilbe from any formula like sumproducts.
thanking you
On 15/03/2011, Paul Schreiner
What does the following code do?especially the array part!
Application.StatusBar = "Please Wait.Loading " & Trim(Prod) & " Data
File"
Workbooks.OpenText FileName:=FileLoc, Origin _
:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, Consecutiv
Yes you are right
For some reason, my XL default format = "*.xls"
Thank you Mr Schreiner.
[image: XL default format.GIF]
On Tue, Mar 15, 2011 at 7:26 PM, Paul Schreiner wrote:
> "Technically" if your Excel 2007 Default Save format is "Excel97-2003"
> format,
> then what you said is true: a ne
you are talking about List of Unique Values
in Excel 2007 you can use "REMOVE DUPLICATE"
in Excel 2003 use : Advanced Filter (Copy to another range / UniqRecords
Only / Criteria = blank)
or you can use a mega-formula see my example workbook at
http://www.box.net/shared/o614r2gnrj
On Tue, Mar
Hi,
Hopefully someone here can help me out.
- I am looking to import the first 50 records in of this URL
http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1&picks=1
- Then I want it to somehow go to the next page and do the same for
the next 50 records until it encounters the
excel is opening a text File
the array are data for column index and length of string string to be
converted to a cells
Array(Array(1, 2), Array(2, 4))
text file contents: "ABCDEFG"
converted to 2 columns
column 1 = "AB"
column 2 = "CDEF"
If you use [Text To Column] ( of DATA menu) you will
14 matches
Mail list logo