Copying data across a workbook -- Office 2003 vs 2007

[RonH]

If I want to copy data from workbook into another workbook, I have always
used this formula in the destination workbook cell: "='workbook1'!D20" where
workbook1 is the name of the workbook and D20 is the row and column within
that workbook where the data is located.

This has always worked fine in Excel 2003.

In Excel 2007, it works sometimes. Other times it returns the formula as
the answer or it returns a 0 value. It does not appear to be consistant. If
I can get it to work it usually will continue to work.

Any ideas on what I am doing wroing.

 

[Shane Devenshire]

Make sure you are not in Formula mode - choose Office Button, Excel Options,
Advanced tab, and in the Display options form this worksheet, make sure the
second option is off -Show formulas in cells instead of their calculated
results. This command has the following toggle Ctrl+` (control plus the `
(back quote - usually found on the key to the left of the 1 key on the top of
the keyboard))

If you are seeing 0 then it suggest the cells are formatted as Text on the
source sheet. If you are seeing formulas another possiblity is the cells on
the target sheet are formatted as Text.