Excel 2003
I have one spreadsheet that I created that does not show the record
count; it immediately displays 'Filter Mode', but never the count.
It's only this one spreadsheet, other spreadsheets display the record

I get the opposite effect when I apply this formula...
=IF(D75=D76,"Balanced","Error")
The answer is "Error", even though the amount is exactly the same in D75
and D76.

I have got the hand of consolidating data from multiple sources, but
when I consolidate non-numeric data - i.e text, it returns 0 by
default for these columns. Is there anything I can do to consolidate
and retain text items?

Is there a limit to how much text you can have in a cell?  Can you expand
that limit?
I have a column of data where each cell of that column has a lot of text in
it.  I have not been able to get the cells in that column (with large text)

Trying to creat a Web Query.  The book says to choose Data, Import
External Data.  I can not find the Data menu.  Can you help me?
Excell 2002, VBA 6.2
Gordon

I have a very large worksheet with a number of people on it. There are
multiple rows of data for each of these people.
I have managed to write code to set up a member tab for each of these
people (over 1000 !) but what I now want to do is copy the data for

I want to show a linked (not embedded) picture based on entry in a
cell.
This way, I can keep the excel spreadsheet light.
Any help?

Im a novice and cant seem to find my answer. Sheet1 in my workbook is a data
buffer  to i simply paste text, sheet 2 organizes the info into a readable
format, but only does this for the pasted data, what i want to do is hit a
button to have the data stored and go onto the next ...

piease help me to how to work with formula section in excel 2007. I am a
mechanical engineer working the piping design . I do no how to multiply cos30
by 2 . please advise me to how to get an online help for the formula
calculation .

I have a workbook with multiple sheets.  On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'.  I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the ...

I'm having a problem with this formula:
=1/(1/b1+1/b2+1/b3+1/b4)
the problem is that sometimes I only enter two values, in cell b1 and
b2. Obviously that generates Div/0 error. How can I "tell" this

Is there any way that you can change the format of a macro to show the A1
format from the R1C1 format as my macro listing shows it as R1C1 and I cannot
make head nor tail of it.  The macro was a recording and I am now editing it
but the following code is as follows :

I have a 1,990 KB Excel 2002 SP3 Workbook that takes for ever to open, save,
update on my Pentium 4 CPU 3.00GHz, 1.00 GB RAM PC.
Are there any simple tricks I can use to make this run faster?

I am in XP-SP2 with XL 2003.
I would like to know when a change is made to any cell on the sheet,
but not every time I open the sheet to consult. It appears that a
recalc is made upon opening.

It seems that my Excel 2003 has adefault which causes any integer that is
entered to be automatically divided by 10 when entered into the cell. Can
anyone please tell me how to remove this annoying feature?
Many thanks in advance.