Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying data across a workbook -- Office 2003 vs 2007
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying data across a workbook -- Office 2003 vs 2007
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "RonH" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ACCESSING A SHARED EXCEL 2003 WORKBOOK ISSUES WITH OFFICE 2007 | Excel Discussion (Misc queries) | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) |