I am trying to install the desktop with out having perms under c::\directory. So I installed the excel under C:\Temp\PortfolioTest folder and trying to use the excel. The data refresh is failing with out any errors (that I could see). If look through the connection properties I am unable to edit the location of the files it is likned to. I dont have power pivot table option in my excel 365. How do i edit the connection properties.?
BTW, the excel looks great and wonderful effort by you. Thanks for that effort in advance.
-M
Comments
At this point you must be able to create folder c:\portfolioslicer to use system. Could you request this permission from your computer admin?