Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Excel refresh fails as path not update (C:/portfolioslicer/PSData): OLE ODBC error
Hello Vidas,
Thank you so much for your file and support. Getting almost there! But when refreshing, I get this OLE OBDC error because the Excel is looking for data stored in c:/portfolioslicer/psdata whereas it is stored somewhere else. Where can I change this location?
Please note the psconfig file has been correctly updated and the external files have been correctly updated as well without errors.
Thank you so much!
Thank you so much for your file and support. Getting almost there! But when refreshing, I get this OLE OBDC error because the Excel is looking for data stored in c:/portfolioslicer/psdata whereas it is stored somewhere else. Where can I change this location?
Please note the psconfig file has been correctly updated and the external files have been correctly updated as well without errors.
Thank you so much!
Comments
For that go to File->Options->Add-ins->Manage: COM Add-ins (Go...)->Check "Microsoft Power Pivot for Excel".
If you have access to PowerPivot interface in your PortfolioSlicer, please follow this document to change your file location:
http://www.portfolioslicer.com/docs/excel2013-change-data-location.html