| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Spreadsheets with formulas attached, between workbooks.
Hi,
I'm encountering broken links after attempting to merge two xls workbooks together...sigh. a formula that was =Sales!P34 becomes: ='C:\...\abc.xls'[sales]!P34 (or some such) locking the formula in the cell directly to the workbook it was created in. Q: How can I make the reference to the Workbook relative? Is there something like... =[thisWorkbook]!Sales!P34 ....not an absolute reference? many thanks ! Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Attached templates become spreadsheets | Excel Programming | |||
| How to keep macros attached when moving sheet to a new workbook | Excel Programming | |||
| Moving between spreadsheets | Excel Discussion (Misc queries) | |||
| Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
| moving macros between spreadsheets | Excel Programming | |||
Threaded Mode
