Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
#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
Posted to microsoft.public.excel.links
|
|||
|
|||
#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
Posted to microsoft.public.excel.links
|
|||
|
|||
#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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet will not open without Excel Application being open fir | Excel Discussion (Misc queries) | |||
Help! I can't get a spreadsheet to open | New Users to Excel | |||
OPen one Spreadsheet from another | Excel Discussion (Misc queries) | |||
#NAME when I open up my spreadsheet | Excel Worksheet Functions | |||
.xls spreadsheet will not open | Excel Discussion (Misc queries) |