excel 2000 to excel 2007
Office button (top left, large), Excel Options, Advanced tab, scroll down and check Update links to other documents
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Eric" wrote in message ...
|I have several workbooks that I made using excel 2000. The company has
| upgraded my computer and put excel 2007 and now I can't link pages like I did
| before.
| Previously:
| I would open the workbook and it would ask to update and I would say yes. I
| could always hit f9 and have it recalculate and it would update the page from
| the other closed workbooks.
|
| Now:
| The workbook just opens and never updates. When I hit f9 it recalculates
| but doesn't update.
|
| What can I do?
|