Excel 2016 Change Source Locks File
Hello Everyone, We recently transitioned from 2010 to 2016 which has been a complete nightmare... a complete nightmare. I don't know how much I can emphasize how much of a nightmare it's been. I am a power excel user and I've been changing links daily for 10 years and have never experienced this until Excel 2016 (in my opinion the worst Excel). Excel File A and File B are the same exact file but in different folders, File C Links to File A but now I want it to link to File B...I have all files open, with File C I change source from A to B...it "completes" in a few seconds but then the cursor continues to circle for 5+ minutes....The links are nothing special and not a lot of information. When we were using 2010 it literally took <10 seconds to do the entire process, now it takes 5+ minutes. PLEASE Help! I have the same issue when I do a control find replace instead of changing links.