Cells wont update unlees other workbook open

Wookie

Board Regular
Joined
Mar 4, 2003
Messages
220
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

Legend
Joined
Sep 3, 2002
Messages
10,473
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.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Wookie

Board Regular
Joined
Mar 4, 2003
Messages
220
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

Legend
Joined
Sep 3, 2002
Messages
10,473
I cannot replicate your results. Is the H drive a shared drive of some sort?
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473

ADVERTISEMENT

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

Legend
Joined
Sep 3, 2002
Messages
10,473
Anybody who knows a fix to this one, jump right in! :biggrin: Have taken a look at the MS Knowledge Base, with no results.
 

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Wookie said:
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,126,993
Messages
5,622,049
Members
415,875
Latest member
Tarali

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top