Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link formulas
The value is in a different tab eg: ='[Duty Free Plan Vs
Actual.xls]Vodka'!$C$99 My problem is that when I flick between spreadsheet, then the formula changes to M:\Finance\Sales Reports FY08\By Markets (Plan Vs Actual)\[Duty Free Plan Vs Actual.xls]Vodka'!$C$99 I would like to keep the original format. How would you solve this and which problems can you oversee with this approach thanks,jose |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link to range of cells, so formulas are retained | Excel Discussion (Misc queries) | |||
Pasting formulas without the link help | Excel Discussion (Misc queries) | |||
Replace all formulas in one worksheet to link to different worksh | Excel Discussion (Misc queries) | |||
link formulas in excel | Excel Worksheet Functions | |||
Formulas link cells | Excel Worksheet Functions |