View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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?