Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct and moving sheets between workbooks error
Hi,
I have a tab with multiple sumproduct formulas. When I select move / copy and copy the sheet to another workbook, both the original and copy of the worksheet now show #VALUE as the result of all of the sumproduct formulas. Has anyone ever encountered this or do you know why it happens? More importantly, any idea on how to fix it? Thanks Tim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct and moving sheets between workbooks error
All
Nevermind.... I was able to figure out the cause. the data the sumproduct was summarizing had a bad link. When you move the tab to another workbook, it forced the formulas to recalculate, causing the #VALUE error. If I get rid of the bad links, everything works. Thanks On Sep 22, 4:15*pm, Tim879 wrote: Hi, I *have a tab with multiple sumproduct formulas. When I select move */ copy and copy the sheet to another workbook, both the original and copy of the worksheet now show #VALUE as the result of all of the sumproduct formulas. Has anyone ever encountered this or do you know why it happens? More importantly, any idea on how to fix it? Thanks Tim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct and moving sheets between workbooks error
Happy to have you here to work it out! :-)
"Tim879" wrote: All Nevermind.... I was able to figure out the cause. the data the sumproduct was summarizing had a bad link. When you move the tab to another workbook, it forced the formulas to recalculate, causing the #VALUE error. If I get rid of the bad links, everything works. Thanks On Sep 22, 4:15 pm, Tim879 wrote: Hi, I have a tab with multiple sumproduct formulas. When I select move / copy and copy the sheet to another workbook, both the original and copy of the worksheet now show #VALUE as the result of all of the sumproduct formulas. Has anyone ever encountered this or do you know why it happens? More importantly, any idea on how to fix it? Thanks Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving / Emailing Macro Workbooks with Custom Toolbars | Excel Worksheet Functions | |||
How do you maintain links when moving workbooks? | Excel Discussion (Misc queries) | |||
Moving workbooks between folders | Excel Discussion (Misc queries) | |||
moving workbooks | Excel Discussion (Misc queries) | |||
Moving sheets between workbooks | Excel Discussion (Misc queries) |