Skip to main content

I am trying to change the Source of my Datasets from Google Sheets to Microsoft Excel Online.

 

I do not see anywhere that I can add the link to the new source or even remove the old source to add a new one. 

 

 

Clicking Google Sheets, only shows me the sheets in the previously linked account. The other two options, Excel and CSV, are upload file options. 

 

The Configure Tab is grayed out as shown. 

 

In the account settings, no account is linked in the Integration, and in the Data Hub, no option to import as seen here:

 

 

Hi ​@Alkandari 

In your situation, refreshing data from Excel Online isn't possible because Lucidchart currently doesn't support dynamic links to Excel. Instead, you can manually update your dataset by uploading a new version. The reason you can't access the Configure tab or link Excel Online is that this functionality is not yet available in Lucidchart's public version

For now, you can update your data source by using the 'Replace Dataset' option to upload a new Excel file. Besides, if you're looking for seamless automatic updates similar to what's available with Google Sheets, you'll need to wait for Lucid's upcoming Excel Online integration feature to be released.

To learn more on this - Data Linking: Replace vs. Refresh your data set in Lucidchart | Community

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards


Hi ​@Alkandari, thank you for posting in the community! You will need to connect to the Lucid Microsoft 365 Excel Integration from the Lucid integrations marketplace before the option is available. This Help Center article has more details on how to manage your data once you have connected and authenticated to the integration. 


Please let me know if that didn’t work for you or if you have any questions! 


Reply