Forum Discussion
How to stop users adding links to other workbooks
Thanks NikolinoDE, yes, the idea is to have a global setting that stop linking workbooks. I can totally see how one can use that feature, but for many users, it just seems to add a level of frustration when links they don't know exist get broken and formulas suddenly stop working.
I would never have found that setting on my own: the labelling just does not seem to be related, so thanks for pointing to the right direction, I'll see if that does the trick.
That said for those on mac (Excel 16.82 on macOS Sonoma), here where to find it.
1 - In the top bar menu, on the left, roll down the Excel menu > Preferences
2 - Click the Edit icon (Top center)
3 - In Second row section (Cut and Paste Options), uncheck the first option: Cut, copy and sort inserted objects with related cells
Arkinien NikolinoDE I've recently noticed this issue both in the desktop version and online. I have unchecked the box for "Cut, copy, and sort inserted objects with their parent cells", but there is no change for me. Copy/paste is still inserting references to the source workbook.
I've noticed that any formula that references an object (a table or sheet) in the workbook will create a reference to the original workbook when I copy and paste from one workbook to another. I've used the source workbook as a template for the target workbook, so the named tabel and sheets exist in the target.