Domo Excel Add-in "Live Data Mode"

Cbrack

I would like to disable "Live Data Mode" in the Excel addin. I've created the excel sheet, saved it, moved it to the business system. On my system, when I select "Refresh all" Live Data Mode stays off. However, on the other system, when I select Refresh All, live Live Data Mode enables again, turns blue. I've tried turning it off and saving the sheet again, but so far it continues to re-enable Live data mode. Any suggestions?

ArborRose

Here are some troubleshooting steps to try:

1. Ensure Compatibility and Versions

• Excel and Domo Add-in Versions: Make sure both systems are running compatible versions of Excel and the Domo Excel Add-in. Sometimes version mismatches can lead to unexpected behavior.
• Domo Account Permissions: Verify that both users have the same Domo permissions, as certain permissions might automatically enforce "Live Data Mode" to ensure data integrity across systems.

2. Check Domo Settings on the Other System

• The Domo Add-in on the other system might have a setting or default that overrides the "Live Data Mode" preference when refreshing data.
• On the system where the issue occurs, go to the Domo Excel Add-in settings and look for any options related to refresh settings or default modes.

3. Disable and Re-enable the Add-In

• Try fully disabling and re-enabling the Domo Add-in on the system with the issue. Sometimes, toggling the add-in or reinstalling it can reset configurations that might have become stuck.

4. Save the Excel File with "Live Data Mode" Disabled Again

• Open the Excel sheet on the affected system.
• Turn off "Live Data Mode" and save the file in a trusted location on that system.
• Close Excel completely, then re-open the sheet and try refreshing to see if it stays off.

5. Check Excel’s Trust Center Settings

• Go to File > Options > Trust Center > Trust Center Settings in Excel.
• Check for any settings related to Trusted Add-ins or Data Connections that might be enforcing the live data connection on refresh. Disabling or adjusting these might prevent "Live Data Mode" from re-enabling automatically.

6. Contact Domo Support

• If none of these steps work, it’s possible that there’s an issue specific to how the add-in functions on that system, and Domo Support might be able to provide additional insight or a patch to fix this behavior.

ArborRose

Here are some troubleshooting steps to try:

1. Ensure Compatibility and Versions

• Excel and Domo Add-in Versions: Make sure both systems are running compatible versions of Excel and the Domo Excel Add-in. Sometimes version mismatches can lead to unexpected behavior.
• Domo Account Permissions: Verify that both users have the same Domo permissions, as certain permissions might automatically enforce "Live Data Mode" to ensure data integrity across systems.

2. Check Domo Settings on the Other System

• The Domo Add-in on the other system might have a setting or default that overrides the "Live Data Mode" preference when refreshing data.
• On the system where the issue occurs, go to the Domo Excel Add-in settings and look for any options related to refresh settings or default modes.

3. Disable and Re-enable the Add-In

• Try fully disabling and re-enabling the Domo Add-in on the system with the issue. Sometimes, toggling the add-in or reinstalling it can reset configurations that might have become stuck.

4. Save the Excel File with "Live Data Mode" Disabled Again

• Open the Excel sheet on the affected system.
• Turn off "Live Data Mode" and save the file in a trusted location on that system.
• Close Excel completely, then re-open the sheet and try refreshing to see if it stays off.

5. Check Excel’s Trust Center Settings

• Go to File > Options > Trust Center > Trust Center Settings in Excel.
• Check for any settings related to Trusted Add-ins or Data Connections that might be enforcing the live data connection on refresh. Disabling or adjusting these might prevent "Live Data Mode" from re-enabling automatically.

6. Contact Domo Support

• If none of these steps work, it’s possible that there’s an issue specific to how the add-in functions on that system, and Domo Support might be able to provide additional insight or a patch to fix this behavior.