Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using External VBA References for 64 and 32 bit XP | Excel Programming | |||
External References in Excel | Setting up and Configuration of Excel | |||
External references | Excel Programming | |||
External References | Excel Discussion (Misc queries) | |||
External References not working right. | Excel Worksheet Functions |