If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing formula links
I have a master spreadsheet that calls on another spreadsheet(a) a
completes the calculation, the problem is it is pointing at the wrong spreadsheet, spreadsheet(a). When I open up the correct spreadsheet, spreadsheet(b) and select the correct cell, I copy it then go the back to the master spreadsheet, select paste special and select 'paste link' this gives me the number from the correct spreadsheet and overwrites the existing data in the master sheet All I want is to take the number from a particular cell in spreadsheet, spreadsheet(b) and add it to a particular cell in the master sheet, what am I doing wrong? Current calculation: =+'C:\Documents and Settings\uuser.DOMAIN\Local Settings\Temporary Internet Files\OLK17D\[Some Spreadsheet - Fixed Assets.xls]12-31-07'!$N $100 What appears when I paste the link: ='[Some Spreadsheet - Fixed Assets New.xls]12-31-07'!$T$61 |
#2
|
|||
|
|||
Changing formula links
Just make sure spreadsheet(a) has first been save in a non-temp location
before using it as the source of links. -- Gary''s Student - gsnu200731 " wrote: I have a master spreadsheet that calls on another spreadsheet(a) a completes the calculation, the problem is it is pointing at the wrong spreadsheet, spreadsheet(a). When I open up the correct spreadsheet, spreadsheet(b) and select the correct cell, I copy it then go the back to the master spreadsheet, select paste special and select 'paste link' this gives me the number from the correct spreadsheet and overwrites the existing data in the master sheet All I want is to take the number from a particular cell in spreadsheet, spreadsheet(b) and add it to a particular cell in the master sheet, what am I doing wrong? Current calculation: =+'C:\Documents and Settings\uuser.DOMAIN\Local Settings\Temporary Internet Files\OLK17D\[Some Spreadsheet - Fixed Assets.xls]12-31-07'!$N $100 What appears when I paste the link: ='[Some Spreadsheet - Fixed Assets New.xls]12-31-07'!$T$61 |
Thread Tools | |
Display Modes | |
|
|