excel 2000 to excel 2007
 

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?

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?

excel 2000 to excel 2007
 

*** Sent via Developersdex http://www.developersdex.com ***