Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Excel for Mac Linked Data Types disabled

Copper Contributor

I created a sheet that contains formulas that reference data from a website (QR creator) and it works as intended. Once I close Excel and then I open it again, the cell in which the QR code is supposed to appear shows "#FIELD!" and there is also a security Warning that reads: "Linked Data Types have been disabled". How do I enable linked data types so the formulas work without me having to refresh each one individually? I cannot find any solutions for EXCEL for Mac.

0 Replies