|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 7th, 2006, 04:24 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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!!! 
|
|
#2
November 7th, 2006, 04:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value error when opening spreadsheet
Some functions do not work when linked to closed external workbooks.
Dave -- Brevity is the soul of wit. " wrote: 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!!!
|
|
#3
November 7th, 2006, 05:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value error when opening spreadsheet
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.) " wrote: 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!!!
|
|
#4
November 7th, 2006, 06:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value error when opening spreadsheet
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. tim m wrote: 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.) " wrote: 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!!!
|
|
#5
November 7th, 2006, 06:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value error when opening spreadsheet
You may be able to replace your =sumif() with =sumproduct().
As Dave F. stated, some functions don't work with closed workbooks. wrote: 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!!! -- Dave Peterson
|
|
#6
November 8th, 2006, 03:22 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value error when opening spreadsheet
Hi everyone,
it works now with the ={sum(if(...))} as an array... Dave Peterson wrote: You may be able to replace your =sumif() with =sumproduct(). As Dave F. stated, some functions don't work with closed workbooks. wrote: 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!!! -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
