ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   External References (https://www.excelbanter.com/excel-programming/398954-external-references.html)

Mike H.

External References
 
I was very careful not to embed external paths in a spreadsheet, but then I
noticed that afterwards, the entire path is now hard-coded in my formulae.
Is there an easy way to change formulae that have f:\mysub\mysub2\[myWB.xls]
in all formulae? What I would really like to do is have the formulae not
refer to a path at all.

joel

External References
 
On the Worksheet Edit Menu - Replace
put the path in the from box and leave the to box empty. Then replace all.

"Mike H." wrote:

I was very careful not to embed external paths in a spreadsheet, but then I
noticed that afterwards, the entire path is now hard-coded in my formulae.
Is there an easy way to change formulae that have f:\mysub\mysub2\[myWB.xls]
in all formulae? What I would really like to do is have the formulae not
refer to a path at all.


Dave Peterson

External References
 
You could use Edit|Replace and replace.
You could use Edit|Links and change the source to the same workbook.

If you're having trouble finding that link,
get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

I bet you're copying formulas from a cell in different workbook.

If you're doing just a single formula, copy from the formulabar and paste into
the formula bar.

If you're doing lots, I like this:

You could select the range to copy
change all the formulas to strings
edit|replace
what: =
with: $$$$$=
replace all

Copy and paste to the new workbook

and change all the strings back to formulas (in both worksheets!)
edit|replace
what: $$$$$=
with: =
replace all

Mike H. wrote:

I was very careful not to embed external paths in a spreadsheet, but then I
noticed that afterwards, the entire path is now hard-coded in my formulae.
Is there an easy way to change formulae that have f:\mysub\mysub2\[myWB.xls]
in all formulae? What I would really like to do is have the formulae not
refer to a path at all.


--

Dave Peterson


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com