2 Excel files

[trkyassin]

Gents
Could you please assist me in the below case:
1- I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one).
2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount in each cell.
3- Excel (A) has the same columns and rows, but has amount in each cell.
4-I referred every cell in Excel (B) to the concerned cell in Excel (A) on my PC.
5-Now I have got my target excel B.
6-Every day I replaced Excel (A) with a new extract from I series , and when I open it , the Excel (B) effected with the new amount of Excel A (according to my previous reference).
My requirement is there any method to let another user to use those 2 Excel files on his PC without changing the reference predefined in Excel (B) Your assist in this regard will be appreciated.
Tarek

 

[dspel79082]

Hi TR, if I'm understanding correctly you want to give him copies to use? If that is the case, and the 2 files are in the same folder on your pc, then putting them together in the same folder on his should work. If not, what you will need to do on his pc is to open the 'edit links' from Excel B and choose 'change source' to redirect the links to the Excel A on his pc.

Debbie S