Forum Discussion

Anonymous's avatar
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 ...
Change Source
excel
Excel 2016
JKPieterse's avatar
JKPieterse
Silver Contributor
Sep 17, 2018
Can you perhaps post a typical formula with an external reference?
Anonymous's avatar
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. 

Resources