Forum Discussion
Solved
Is anyone else getting OneDrive access error when trying to use the Data Visualizer in Excel?
Our organization doesn't use OneDrive. Suddenly this week the Data Visualization add-in for Excel is requiring it to save a new visualization in an Excel spreadsheet. I checked our version of ...
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.
Yes. We want to be able to save the file in SharePoint instead of OneDrive, if not locally. After reading those two articles, I made sure I was logged in to my work account. It insists on using only OneDrive and won't allow anything else.
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.
mduCantoo , you are welcome, glad to know you sorted this out.
- Yes! That did the trick. If I start with the Excel file being in SharePoint, I can open it in the desktop application and am able to add the Data Visualizer and, by editing the cells in the Excel, manipulate the diagram, changing labels, connections, shapes, etc. but not edit the drawing itself, which is the expected behavior when using it without a Visio license. I am also able to open the diagram in Vision for the Web and save the diagram as an image, pdf, Visio file, etc. and to share or print it.
Our Global Admin has turned off the webstore for Excel on the Web, but that is a completely different issue that I can take up with them.
Thank you, Sergei!