A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Master Spreadsheet with Links to Excel 2003 and Excel 2007 Sheets



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2009, 04:48 AM posted to microsoft.public.excel.links
Alex Zimmerhaven
external usenet poster
 
Posts: 16
Default Master Spreadsheet with Links to Excel 2003 and Excel 2007 Sheets

First of all I want to thank all of those responding to these questions.
Thank you so much for your time! You guys are livesavers!

Here's the issue that I'm having. A group of my users is opening an Excel
2007 file that has external links to other Excel files. In addition, the
linked Excel spreadsheets contain secondary or tertiary links to other Excel
spreadsheets. Not all of the spreadsheets are in Excel 2007 format. Some of
them are Excel 2003. At some point in the process, one of the users began
updating the Excel 2003 files to Excel 2007 format. But, not all of them were
migrated. This caused the calculations in the main (for our example I am
calling it "Master") spreadsheet to fail. All Cells had the following error:
"#VALUE!".

We initially thought it may be the links, so we cleaned up the Master
Spreadsheet's Links and verified them all. But, when trying to update the
links (either automatically by changing the setting to "enable automatic
updating of links") or manually (by clicking Links on the data ribbon and
manually updating them) the links showed an OK status, but the values in the
Master Spreadsheet's cells still contained the error "#VALUE!".

I ran across a suggestion in another thread to open all the linked
spreadsheets and the master spreadsheet and then click CTRL+ALT+F9 to force a
recalculation of all cells in all spreadsheets. This did update the Master
Spreadsheet with the correct values and the error went away. However, when
you attempt to make any changes to the Master Spreadsheet and save the
changes, the error reappears and the calculations do not work.

I have not tried to open every file past the first level of links at the
same time as of yet. I may do that next. I know for a fact that there is the
Master Spreadsheet with at least three levels of linked spreadsheets or more.
And I know that the linked spreadsheets contain both versions of Excel.

My question is, how do I fix this so that it quits breaking every time
changes are made to the master spreadsheet?

Thank you again to anyone that has any suggestions!

-Alex
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.