Settings: Disable Automatic Refresh of Data types

FAQ: How do I disable the automatic refresh of data types in Excel?

Disable All Linked Data Types Globally (Advanced – Applies to All Workbooks)

This method disables the automatic refresh of linked data types in Excel, including those provided by the LightBox add-in.

1. Open Excel and go to the File tab.

2. Click Options.

3. In the Excel Options window, choose Trust Center (bottom of the left pane).

4. Click the Trust Center Settings… button.

5. In the Trust Center dialog, select External Content.

6. Under Linked Data Types, select:

   “Disable all Linked Data Types”

7. Click OK to close each dialog box.

8. Close all open Excel workbooks and restart the Excel application.