problem getting data from connected workbooks

March 19, 2012 at 08:24:32
Specs: Windows XP
I have an Excel 2010 workbook that connects to two other 2010 workbooks. It does a SUMIF of the connected workbooks to give me figures for the main workbook. When I open the main workbook, I select the 'update' option from the dialog box, but in all the cells where the SUMIF appears, I get #VALUE appearing. If I then open the other two workbooks, the #VALUE changes to the correct values. It's not practical to have these other two workbooks open all the time in case someone wants to open the main workbok. Any ideas?

See More: problem getting data from connected workbooks

Report •

March 20, 2012 at 03:52:50
Tried it and it works - thanks a lot!

Report •
Related Solutions

Ask Question