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  

#VALUE! in cells when I open spreadsheet



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2008, 05:51 PM posted to microsoft.public.excel.links
Tim Chapman
external usenet poster
 
Posts: 1
Default #VALUE! in cells when I open spreadsheet

I have a spreadsheet with links to other excel files. (All excel 2003). When
I open the spreadsheet, the cells all show #VALUE! until I open the other
spreadsheets that the links refer to. Is there any to fix this so that the
updates work without opening the other spreadsheets.

Thank you advance.

Tim
  #2  
Old May 1st, 2008, 12:41 AM posted to microsoft.public.excel.links
Dave Peterson
external usenet poster
 
Posts: 19,791
Default #VALUE! in cells when I open spreadsheet

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Tim Chapman wrote:

I have a spreadsheet with links to other excel files. (All excel 2003). When
I open the spreadsheet, the cells all show #VALUE! until I open the other
spreadsheets that the links refer to. Is there any to fix this so that the
updates work without opening the other spreadsheets.

Thank you advance.

Tim


--

Dave Peterson
  #3  
Old May 1st, 2008, 01:01 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default #VALUE! in cells when I open spreadsheet

Some formulas are too difficult for Excel to evaluate without opening
the source workbook. (SUMIF is often cited).

One solution that sometimes works is to open the sources so that all
formulas give correct results then save the workbook and exit. On
re-opening the workbook (without the source workbooks being open,
errors will sometimes disappear).

The reason would be that it was last saved by a previous version of
Excel; on opening again in the later version a full recalculation is
performed and some formulas are then found to be too hard to compute
without fully opening the source workbooks.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

 




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 07:37 PM.


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