Forum Discussion

Anonymous

Sep 16, 2018

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 ...

Silver Contributor

Sep 17, 2018

Can you perhaps post a typical formula with an external reference?

Anonymous
Sep 17, 2018
Jan,

The formula is simple: cell A1 in Workbook C = A1 in Workbook A/B.

I have an update, and I think I have been able to narrow down what is potentially causing the issues. Yesterday, I was upgraded to 64-bit Excel version, and I was able to use the "control find replace" and change source functions just fine; however, our organization uses software that profiles desktop/computer, and my new computer had not been updated with that software. This morning my desktop was profiled (identically resembles my old PC), and when I tried the same functions, the required 15+ minutes. Also, I found a Citrix 2010 and 2016 Excel versions on my computer and in those instances, I was able to perform the changes source and "control find replace" without any issues.