Forum Discussion
Is anyone else getting OneDrive access error when trying to use the Data Visualizer in Excel?
If you save new file on SharePoint and after that start to create something with Add-in, it saves data on this SharePoint site.
If you start with add-in on not saved file, or saved locally, add-in saves data on OneDrive.
How do we tell Windows 10, Excel, Visio, Word, SharePoint, etc. that we do not use OneDrive so it doesn't stop our users from using the O365 products?
Info for: SharePoint in Microsoft 365 Office for business Microsoft 365 admin SharePoint Server 2019 OneDrive (work or school) Office.com OneDrive (home or personal) OneDrive (work or school) operated by 21Vianet OneDrive for Business OneDrive for Mac OneDrive for Windows SharePoint admin center SharePoint in Microsoft 365 Small Business SharePoint operated by 21Vianet
Turn off, disable, or uninstall OneDrive
You find in the Link many usefull informations.
Like: If you want to remove a OneDrive folder from your computer, follow the steps in Choose which OneDrive folders to sync to your computer.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Thank you again for the information. I had found that article and uninstalled OneDrive from my computer. OneDrive was already disabled on my machine and, even after uninstalling it, Excel still insists that I need to set up OneDrive before it will let me use the Data Visualizer Add-in.
My understanding is that Data Visualizer Add-in keeps created diagrams on OneDrive under user account. Diagrams itself are generated on Microsoft server based on data is sent to the server from your file. Add-in actually is only organizes data exchange with the server and shows result.
You need to have Visio Desktop to keep everything within app.
- According to the article, "With the Data Visualizer add-in, you don't need Visio to create a diagram. The same is true for sharing the diagram with others" and it also says we can edit it in Visio on the Web without a license. (https://support.microsoft.com/en-us/office/about-the-data-visualizer-add-in-for-excel-6a108d96-16e6-42c5-b547-8b09ac1119df) unless I am misunderstanding, which is always possible. This next article also makes it sound like you don't need the Visio license for simple creation and editing. (https://support.microsoft.com/en-us/office/the-data-visualizer-add-in-is-designed-for-microsoft-365-work-and-school-accounts-461ec212-9d29-4415-b7af-4fa5833eee92?ui=en-US&rs=en-US&ad=US)
Surely there is a way to use it without using OneDrive. I guess we will need to put in a help ticket with Microsoft to get the information on how to do that, so that the data visualization can be saved with the Excel file.