Formula Shortcut
I need an excel expert that knows a shortcut that will allow me to convert the follwing formula =+'[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L181+'[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L317 to =+'Staff Plan - FY13'!L181+'Staff Plan - FY13'!L317
»
- bakerbe's blog
- Login or register to post comments
- 3018 reads
Remove formula links
Hi,
The following suggestion will works if you have a sheet with name 'Staff Plan - FY13' in the workbook which contain the formula:
1) Go to Ribbon -> Data -> Edit Links.
2) Select the source. In your example this should be Wexford MD Staffing Audit Phase I Oct 2012 x.xls.
3) Press Change Source... button.
4) Navigate to the current workbook, select it, and press OK.
This will remove links and your formula will become from
= '[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L181 + '[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L317
to
= 'Staff Plan - FY13'!L181 + 'Staff Plan - FY13'!L317
Best regards.