Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data not updating in linked workbook
I have two workbooks that I was trying to link together. Workbook 1 holds
the data and the information went on to workbook 2 but it's not updating when you change the data in workbook 1. I have something wrong in my formula =SUM('C:\My Network Places\TMFolder\2009 Trip Points\[2009 Trip Points A-B.xls]Air Mech'!D36) What should I be using. Please keep it simple, not an advanced user. thanks. Teri |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data not updating in linked workbook
First, you don't need the =sum() function. You're not adding multiple cells.
You're just retrieving the value from a cell in that workbook. Second, I'd guess that you don't have both workbooks open in the same instance of excel. Open excel and then use File|open to open both files. (Your formula includes the drive and path. These wouldn't be included if both workbooks were open in the same instance.) Teri wrote: I have two workbooks that I was trying to link together. Workbook 1 holds the data and the information went on to workbook 2 but it's not updating when you change the data in workbook 1. I have something wrong in my formula =SUM('C:\My Network Places\TMFolder\2009 Trip Points\[2009 Trip Points A-B.xls]Air Mech'!D36) What should I be using. Please keep it simple, not an advanced user. thanks. Teri -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
updating linked data | Excel Discussion (Misc queries) | |||
Updating Linked Data in Excel | Excel Discussion (Misc queries) | |||
Updating Linked data in Excel | Links and Linking in Excel | |||
cells linked to others in same workbook not updating | Excel Discussion (Misc queries) |