links not updating

  • Thread starter Thread starter Utkarsh
  • Start date Start date
U

Utkarsh

Hi
I have two files. Data in File 1 is linked to data in file 2. I have
both the files open. When I change a value in file 2, the data in file
1 should update automatically. This doesn't seem to be happening. I
have to go to each cell and hit F2 for the update to happen. I've tried
both F9 and Shift-F9. The calcuations are set to automatic but still it
doesn't update uatomatically. Any idea what is happening?

Thanks
Utkarsh
 
Do you have calculation set to automatic (tools|Options|calculation tab)?

If yes, are you sure you have both workbooks open in the same instance of excel?

If you click on Window (on the toolbar), do you see both workbooks at the bottom
of that dropdown?

If no, then close one of the instances of excel and then go to the other
instance and use File|Open to open the other file. Then try it again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing formulas to values 2
Refreshing F9 vs. F2 2
Difference between F9 and Shift+F9 7
link update within workbook failing 6
Security Warning 5
Reevaluate formula/function in cell 1
Add-ins and #NAME errors 5
Paste link only - not value 4

Back
Top