Changing vlookup location

H

hitchenfoods

We have a number of large spreedsheets which are used daily. Some of th
vlookups refer to spreedsheets located elsewhere on the network. In th
past these have worked fine. Just recently the vlookups seem to hav
changed, ie previously a lookup would have looked at say

T:\nickyh\Weekly Figures\WC 15102004\[Weekly Plan 151004.xls]W''kl
Sum'!$A$11:$BR$478,'C:\PROGRAM FILES\MICROSOF
OFFICE\OFFICE\XLSTART\nickyh\Weekly Figures\WC 15102004\[Weekly Pla
151004.xls]W''kly Sum'!BP$1,0)


but now they look at
=VLOOKUP($A11,'C:\PROGRAM FILES\MICROSOF
OFFICE\OFFICE\XLSTART\nickyh\Weekly Figures\WC 15102004\[Weekly Pla
151004.xls]W''kly Sum'!$A$11:$BR$478,'C:\PROGRAM FILES\MICROSOF
OFFICE\OFFICE\XLSTART\nickyh\Weekly Figures\WC 15102004\[Weekly Pla
151004.xls]W''kly Sum'!BP$1,0)

They now seem to be looking locally in the XLSTART directory. We ar
using Excel 97 but a couple of users use office XP whith the transitio
set to Excel 97. The two have worked well together for about a year an
we havnt had any problems.

Can anyone offer any help please
 
M

Myrna Larson

I believe Excel changes the references for you if you have both workbooks open
and save the one in a different directory. Could someone have done that?
 

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

That pesky SBCMSYNC.DLL error... 3
multiple inputs, multipul outputs (part 2) 3
Arrays Take too long. VERY HARD QUESTION. my head hurts : / 1
Array Formulas take waaaay too long... 7
Word Error Message: This file is corrupt and cannot be opened 1
Cost Field Changes when number are pasted into a Cost_X or Number_X field 1
PROGRAMMERS - We could all use a good laugh 10
Still more on loading a .CSV into a .XSLS 15

Top