Sumif Error when Referenced Wkbk not open

M

Maverick_TG

In Excel Wkbk A, I have several sumif formulas pulling from Excel Wkbk
B. For some reason, the formula results in an error whenever the
referenced Wkbk B is not open. Once opened, the error is resolved.
Any suggestions to have Wkbk B closed without the error values?

I am operating in MS Excel 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use current year in macro 1
VBA referencing disappears with 2007 upgrade 1
How can I best "scrub" a wkbk of "phantom macros"? 7
How to add condition to coding? 1
For Each loop leaves file open after .close 4
Ghostly presence of Excel process 9
Automating Excel with add-in 2
Problem with handling on error when file is already open 3

Top