|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
06-07-2012, 03:06 PM
|
|||
|
|||
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 
|
| Tags |
| #ref!, table refference |
|
|
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 |
 Shared Workbook
|
SJT | Excel | 6 | 01-12-2012 11:33 AM |
| Shared Excel workbook | eguru2 | Excel | 0 | 07-12-2011 12:02 AM |
|
macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
|
Select a range in one one workbook while working in other workbook
|
Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode