When I paste an "IF" function and then edit any of the result-"arguments",
the function then stops acting as a function and appears as text in the cell
it is supposed to operate in.
Example: I paste (in a cell):

software windows vista home premiun additions x32 office standard 2007
I have an Excel workbook (the "Call Workbook) which opens, updates, and
saves several other workbooks (the "Data Workbooks").  Each of the Data
Workbooks have several web queries.  After any Data Workbook is ...

Good day folks!
An (MS Access) call to a workbook (via FollowHyperlink) generates "Reference
is not valid". If the book is saved and re-opened manually there is no
errror, and all cells/formulae/references seem to be OK?

If I enter an eighteen-digit number, 123456789012345678 the number that is
stored in excel 2003 is 123456789012345000, the last 3 digits are "converted"
to zeros.  Is this an undocumented feature?  What can I do to get around
this?  I have 18-digit g/l account numbers and can't ...

I have a large amount of data in one excel file and another file with Dsums
looking in to it to produce a readable document. Every time I open the file I
have an out of memory message and errors on many summs. However if I open the
source file and then close it again all the ...

I think I have stumbled upon a bug in Excel 2003. I routinely use Excel to
make graphs that compare several different series across hundreds of data
points. Only about 10% of my data points have actual names (randomly spaced)
and therefore only these points have a label that I ...

I have a lookup formula that sometime returns a #N/A error.  I would like a 0
to appear if the lookup result is n/a.
Here is my formula:  =VLOOKUP(E3,'Source Pivot Master'!$A$3:$W$60000,7,FALSE)
Thank you.

A user in my office is consistently getting an error when saving a file while
looking at it in Page Break Preview.  Excel saves the file under some kind of
temp or recovery name.  Any thoughts on this?  I've tried doing a
repair/reinstall, but that didn't help.  Any help would be ...

Hello, I have a Excel created using Office 2003 in XP. It contains 6 sheets
with 2 simple macros. If i insert a row in any sheet, save and try to open
the Excel, i get a message saying it is corrupted. Please help.
Below is the error.

My boss created a file in Excel that consists of two small spreadsheets.  For
some reason, Excel thinks this file covers the entire spreadsheet down to the
last row (65536).  This is causing the file to be over 3 mb.  I tried
deleting all of the rows below the spreadsheet...or ...

In a new worksheet into which I have copied formulas & number formats from
previous worksheets, the formulas in the new worksheet are not working
correctly.  The formulas are for subtraction in one and conversions in the
other column.  How can this be fixed?

All of my columns in my spreadsheets (either existing or new) now have
numbers at the top of the header instead of letters. This really messes with
the formula for me. Anyway I want to correct this but I do not know what
caused this. It is almost like a default in the format of ...

Some of my spreadsheets have had the columns numbered in place of alpha. Is
this due to them being created in an older version of Excel and now being
updated into Excel 2003. The numbered columns show formula that is not
standard. eg =Sum(F4:F27) has some unknown formula but the ...

Hi
I have been using a excell sheet with out any problem for several month, but
suddenly one member in the group can't save the excell file. He get's the
following message:

when I select a column and go to format cells, number, date, and any format
of a date
and then type in a number in a cell as 101507 - it comes up in the cell as
11/29/77