Henrik Hougaard
New Member
- Joined
- Jun 16, 2002
- Messages
- 14
When I copy a formula from one workbook to another I get a link to the original workbook i.e.
=(0,06*'[Energi Fyn_2 - test.xls]skema2_soliditet_balance'!$F$26)
Is there a way to copy the formula without the link to the workbook ([Energi Fyn_2 - test.xls]) but still keeping the reference to the sheet (skema2_soliditet_balance'!$F$26)?
=(0,06*'[Energi Fyn_2 - test.xls]skema2_soliditet_balance'!$F$26)
Is there a way to copy the formula without the link to the workbook ([Energi Fyn_2 - test.xls]) but still keeping the reference to the sheet (skema2_soliditet_balance'!$F$26)?