Cells wont update unlees other workbook open

[Wookie]

I have a sheet where the formulas relate to cells in other workbooks. i get N/A error unless the other workbook is open. Any ideas?

 

[just_jon]

Your sure the value in Month is an exact match for cell E4? To test, in an unused cell, enter --

=Month='H:\Submitted Packs\[CoA Ltd.xls] JVB ' !$E$4

and see if it returns TRUE.

 

[Wookie]

I changed your formula a little bit and used the below. It gave me a TRUE. This has got me stumped

EXACT(Month,'H:\Submitted Packs\[CoA Ltd.xls]JVB'!E$4))

 

[just_jon]

I cannot replicate your results. Is the H drive a shared drive of some sort?

 

[Wookie]

Indeed it is. will this make a difference?

 

[just_jon]

I'm beginning to suspect so, as there is no other logical alternative. I've not got access to one [sharde drive], myself, but perhaps someone who has will know. [The help file is silent on the issue.] I've saved it to a 2nd hard drive on my machine, closed out the file, and the formula works fine.

 

[just_jon]

Anybody who knows a fix to this one, jump right in! Have taken a look at the MS Knowledge Base, with no results.

 

[just_jon]

Month equal Jan, This in cell E4 in the JVB sheet. The formula works when i change Month to Feb, Feb is shown in F4 in JVB sheet.

Wookie -- If the formula finds Feb when the WB is closed, the problem is not a system problem, but a data problem of some sort. Double check the Month setting -- is it a computed cell? Are any of the values in the 1st row - especially E4 - computed/subject to change?