…when writing #Excel formula
Note: This post is not about “security” issue π€·ββοΈ
Is the following message familiar to you?

I wonder… when you see this message, which button would you click?Β Please let me know by leaving comments below.
From my observation, most people would click “Don’t Update” when they are dealing with a workbook that was prepared by others.
Why is that?
Because most of the time they don’t have access to a “workbook” that is saved in someone else PC.Β Even the workbook (the external link) is saved in a shared folder, are you sure your counterparts have access right to that shared folder?
If a user cannot “update” the value the first (few) time they opened the file, he/she would have a tendency to click “Don’t Update” the next time they open the same file…. and worst still, he/she builds a habit of “Don’t Update” every time they see the message, which is super dangerous as he/she may not be working with the updated data that they need.
So, the question is:
Shall I link to external workbooks when writing Excel formula?
Continue reading →
If you like it, please share:
Like this:
Like Loading...