 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006#value error when opening spreadsheet
Help!! I have a spreadsheet which is linked to about 30 other spreadsheets. Most of the functions are just 'sum's and 'sumif''s. When I have all spreadsheets open, the values are updated in the main spreadsheet. If I close the linked spreadsheets, I will lose the values to the main spreadsheet. The resulting error is '#value'. All the links are linked properly to the right spreadsheet. I've also opened them one at a time and saved my main spreadsheet. What else can I do? Thanks in advance!!! Some functions do not work when linked to closed external workbooks. Dave  SignatureBrevity is the soul of wit. > Help!! I have a spreadsheet which is linked to about 30 other > spreadsheets. [quoted text clipped - 10 lines] > > Thanks in advance!!! Not totally sure about how to rectify your problem but if you want to work on the summary spreadsheet as a snap shot in time of the other sheets, have you tried copy all of the summary sheet and then 'paste special'.....'paste values' to a new sheet? this will essentially give you all of the data as values rather than formulas and you should be able to close all other sheets and just work on your 'snap shot summary sheet'. (Always remember to backup any worksheets to a different location on your computer before trying anything new to your exisiting sheets in case something goes wrong.) > Help!! I have a spreadsheet which is linked to about 30 other > spreadsheets. [quoted text clipped - 10 lines] > > Thanks in advance!!! Thanks all... I have pasted as values to temporarily solve the problem. That will have to do the trick for now. I was just wondering if there was any solution to my problem. > Not totally sure about how to rectify your problem but if you want to work on > the summary spreadsheet as a snap shot in time of the other sheets, have you [quoted text clipped - 21 lines] > > > > Thanks in advance!!! You may be able to replace your =sumif() with =sumproduct(). As Dave F. stated, some functions don't work with closed workbooks. > Help!! I have a spreadsheet which is linked to about 30 other > spreadsheets. [quoted text clipped - 10 lines] > > Thanks in advance!!! SignatureDave Peterson Hi everyone, it works now with the ={sum(if(...))} as an array... > You may be able to replace your =sumif() with =sumproduct(). > [quoted text clipped - 14 lines] > > > > Thanks in advance!!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.