Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2012, 01:41 AM
tanababa tanababa is offline #REF! error when opening a workbook that contain a refference to another workbook Windows 7 #REF! error when opening a workbook that contain a refference to another workbook Office 2007
Novice
#REF! error when opening a workbook that contain a refference to another workbook
 
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
  #2  
Old 06-07-2012, 03:06 PM
cplmckenzie cplmckenzie is offline #REF! error when opening a workbook that contain a refference to another workbook Windows 7 64bit #REF! error when opening a workbook that contain a refference to another workbook Office 2010 64bit
Novice
 
Join Date: Apr 2012
Posts: 4
cplmckenzie is on a distinguished road
Default

tanababa,

From what i saw when testing....

In Calculation.xlsx, row 4 you are referencing a sheet in Source.xlsx "Table1" that does not exists. I changed it From Calculated Data to Table1, it read the sheet data.

In row 5, it appears that you are attempting to access a file from the hard drive with
illegal characters []! are not allow in disk file access.

cplmckenzie
Reply With Quote
  #3  
Old 06-07-2012, 03:11 PM
cplmckenzie cplmckenzie is offline #REF! error when opening a workbook that contain a refference to another workbook Windows 7 64bit #REF! error when opening a workbook that contain a refference to another workbook Office 2010 64bit
Novice
 
Join Date: Apr 2012
Posts: 4
cplmckenzie is on a distinguished road
Default

tanababa,

Yes just change the sheet name and the formula to reference the same sheetname

cplmckenzie
Reply With Quote
Reply

Tags
#ref!, table refference

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM
#REF! error when opening a workbook that contain a refference to another workbook Shared Workbook SJT Excel 6 01-12-2012 11:33 AM
Shared Excel workbook eguru2 Excel 0 07-12-2011 12:02 AM
#REF! error when opening a workbook that contain a refference to another workbook macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
#REF! error when opening a workbook that contain a refference to another workbook Select a range in one one workbook while working in other workbook Slow&Steady Excel 1 02-21-2010 03:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft