• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find and Replace in Chart, Merged cells, Conditional Formatting

7effrey

New Member
Hi all,

I'm currently rebuilding our excel sheet due to frequent corruptions. However, everything i copy contains a link to the original sheet [Program review report_v129_Rebuilt.xlsb], but it seems like i can't simply Find and Replace this. Are there any fast way of replacing this?
 
7effrey

Firstly, Welcome to the Chandoo.org Forums

Goto the Data Tab
Edit Links
Find the link and change it to the new workbook, it may be the file you are in
 
Hi Hui,

Thanks, I have already tried that, and it cannot continue because of the merged cells. I think it wants me to unmerge them all, before i can do it. I have alot of merged cells, and it will take time to merge it again - so i want to prevent that. is it possible?
 
Back
Top