Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas not working after transfering to new workbook
Hello,
I created a workbook with formulas that work with links to other worksheets. When I copied it to a disk and saved it to my work computer the formulas do not work. Here is one of the formulas: =SUM{(('Procurement Gateway '!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement Gateway '!J3:J220))} This works on the disk that I saved it on, but does not work on my compter at work. I get this error: #VALUE! What am I doing wrong? Any help is appreciated. Thanks! Mark Jackson |
#2
|
|||
|
|||
Hi
have you entered this formula as array formula? -- Regards Frank Kabel Frankfurt, Germany Mark Jackson wrote: Hello, I created a workbook with formulas that work with links to other worksheets. When I copied it to a disk and saved it to my work computer the formulas do not work. Here is one of the formulas: =SUM{(('Procurement Gateway '!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement Gateway '!J3:J220))} This works on the disk that I saved it on, but does not work on my compter at work. I get this error: #VALUE! What am I doing wrong? Any help is appreciated. Thanks! Mark Jackson |
#3
|
|||
|
|||
Mark,
Check the path of the referenced worksheet(s) in the formula(s). They may be pointing to a worksheet(s) in another workbook(s). "Mark Jackson" wrote: Hello, I created a workbook with formulas that work with links to other worksheets. When I copied it to a disk and saved it to my work computer the formulas do not work. Here is one of the formulas: =SUM{(('Procurement Gateway '!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement Gateway '!J3:J220))} This works on the disk that I saved it on, but does not work on my compter at work. I get this error: #VALUE! What am I doing wrong? Any help is appreciated. Thanks! Mark Jackson |
#4
|
|||
|
|||
Yes.
"Frank Kabel" wrote: Hi have you entered this formula as array formula? -- Regards Frank Kabel Frankfurt, Germany Mark Jackson wrote: Hello, I created a workbook with formulas that work with links to other worksheets. When I copied it to a disk and saved it to my work computer the formulas do not work. Here is one of the formulas: =SUM{(('Procurement Gateway '!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement Gateway '!J3:J220))} This works on the disk that I saved it on, but does not work on my compter at work. I get this error: #VALUE! What am I doing wrong? Any help is appreciated. Thanks! Mark Jackson |
#5
|
|||
|
|||
Hi
should work. Have you tried: - hitting F9 - checking that the source range does not contain an error -- Regards Frank Kabel Frankfurt, Germany "Mark Jackson" schrieb im Newsbeitrag ... Yes. "Frank Kabel" wrote: Hi have you entered this formula as array formula? -- Regards Frank Kabel Frankfurt, Germany Mark Jackson wrote: Hello, I created a workbook with formulas that work with links to other worksheets. When I copied it to a disk and saved it to my work computer the formulas do not work. Here is one of the formulas: =SUM{(('Procurement Gateway '!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement Gateway '!J3:J220))} This works on the disk that I saved it on, but does not work on my compter at work. I get this error: #VALUE! What am I doing wrong? Any help is appreciated. Thanks! Mark Jackson |
#6
|
|||
|
|||
Josh,
What I did is I copied the workbook here at work and loaded it on my notebook computer then I added the worksheet with all the formulas and made sure it was working properly. Then I inserted it to the original workbook here at work. Now it is not working. I doubled checked to make sure the paths are correct. They are identical to the file I have on my notebook computer. Any suggestions? "Josh" wrote: Mark, Check the path of the referenced worksheet(s) in the formula(s). They may be pointing to a worksheet(s) in another workbook(s). "Mark Jackson" wrote: Hello, I created a workbook with formulas that work with links to other worksheets. When I copied it to a disk and saved it to my work computer the formulas do not work. Here is one of the formulas: =SUM{(('Procurement Gateway '!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement Gateway '!J3:J220))} This works on the disk that I saved it on, but does not work on my compter at work. I get this error: #VALUE! What am I doing wrong? Any help is appreciated. Thanks! Mark Jackson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
Formulas not working | Excel Discussion (Misc queries) | |||
Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Formula's not working | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |