Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 30th 08, 05:51 PM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
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   Report Post  
Old May 1st 08, 12:41 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
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   Report Post  
Old May 1st 08, 01:01 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet will not open without Excel Application being open fir Deirdre Lysaght Excel Discussion (Misc queries) 1 November 13th 07 04:11 PM
Help! I can't get a spreadsheet to open [email protected] New Users to Excel 1 August 20th 06 10:02 PM
OPen one Spreadsheet from another Nigel Excel Discussion (Misc queries) 1 June 9th 06 10:34 PM
#NAME when I open up my spreadsheet Muttley Excel Worksheet Functions 2 October 21st 05 01:20 PM
.xls spreadsheet will not open David Excel Discussion (Misc queries) 1 August 17th 05 12:01 AM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017