Excel automatically adds path to external reference -> formula too long

R

Roland

Excel 2000 SR1 / Windows 2000

I have moved a large Excel application to a new folder. However this creates
the following problem:
I have many external references to other Excel files located in the SAME
folder.
Fields with references such as:
'[File1.XLS]Sheet1'!C50 + '[File1.XLS]Sheet2'!C50 + ...
are automatically converted by excel into:
'D:\Full path\[File1.XLS]Sheet1'!C50 + 'D:\Full path\[File1.XLS]Sheet2'!C50
+ ...
This results finally into errors, since the formula becomes to long to fit
into a single field.

Can anyone please give me a hint, how to turn this automatism off?

Thanks
Roland
 

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

How can I automatically change the path names of Excel OLE objects in Word Document 3
formula update external reference excel 0
VBA HELP! MsgBox & File & Sumif ****** 5
VBA Sumif *********************** Help 2
AutoDetect the path of the file? 4
Filename in a formula generated automatically? 1
Pointer-like behaviour in Excel possible to build formulas? 8
WARNING: Opinion 4

Top