- Joined
- Jan 12, 2010
- Messages
- 1
- Reaction score
- 0
I'm probably missing something very simple... I'm a new user of Excel 2007, but lots of 2003 experience...
I have a bunch of workbooks with multiple worksheets
I want values to be shared between them. But when I open only one or two workbooks, the values from the workbooks which are still cloesed does not appear.
In 2003, the data was still present in the opened workbook.
I have checked the Advanced settings in the Excel Options in the Office symbol under "When Calculating this workbook" and they are checked for "sUpdate links to other documents" and checked for "Save external link values"
Anyone got any ideas. This is preventing the spreadsheets from working correctly.
Thanks,
Andy
I have a bunch of workbooks with multiple worksheets
I want values to be shared between them. But when I open only one or two workbooks, the values from the workbooks which are still cloesed does not appear.
In 2003, the data was still present in the opened workbook.
I have checked the Advanced settings in the Excel Options in the Office symbol under "When Calculating this workbook" and they are checked for "sUpdate links to other documents" and checked for "Save external link values"
Anyone got any ideas. This is preventing the spreadsheets from working correctly.
Thanks,
Andy