Thread: [Solved] #REF! error when opening a workbook that contain a refference to another workbook
View Single Post
 
Old 06-06-2012, 01:41 AM
tanababa tanababa is offline Windows 7 Office 2007
Novice
  
Join Date: Aug 2010
Posts: 10
tanababa is on a distinguished road
Default #REF! error when opening a workbook that contain a refference to another workbook
Hi,
I have attached two files. Source and Calculation.
With in the Calculation file I have two reffernces to a cell that is in the Source workbook.

When using the table naming refference I get an error as soon as I update the workbook.
='C:\Users\Tamir\Dropbox\Source.xlsx'!Table1[[#Totals],[D]]

When using the relative form of refference I do not get the error
='C:\Users\Tamir\Dropbox\[Source.xlsx]Data Source'!J13

Why is that?
It is a crucial problem because I gae many emails with excel attachments without their source files.

Thank you,
Tamir
Attached Files
File Type: xlsx Source.xlsx (9.3 KB, 13 views)
File Type: xlsx Calculation.xlsx (9.0 KB, 11 views)
Reply With Quote