Hi,
To explain, I have over 10,000 linked formulae in a spreadsheet that require a change in the link. What I've done is turned them into text so I can use search and replace. This is an example of what I'm left with. '='p:\Binding Reports\Data Input\2014\[November 2013.xlsx]J BLOGGS'!$AH$71
I now want to replace '= with = to return it to a formula but I get the message "Microsoft Excel Cannot Find a Match".
Can anyone help please?
Regards
Mark
ps I inherited the spreadsheet.
Try press Ctrl+F , click on Replace type in '= and replace with =
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
Stating the obvious I suppose but why do you need to turn them into text in order to change the linked file, which I assume is your intention?
Why not simply use the Connections...Edit Links...Change Source, and select the new file name to which you want to link?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks