Forum Discussion
How to stop users adding links to other workbooks
Hi, We use Excel for preparing budget files. These files then get collated in MS Power BI for group wide analysis. One issue we have is that users can sometimes paste links from spreadsheets on the...
I am having this same issue. We use a standard template that users download and complete. The file has embedded logic, data validations and defined pivots. Many users are are saving / copying the data into the template that results in data corruptions, link issues and content enablement warning. The handling of the file seems to pickup every storage location along the way. This is degrading the effectiveness of this tool.
This issue is not Hyper Links but the embedded references to name ranges that get corrupted.
How can this be prevented?
