web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Analysis Cubes-Unhandl...
Microsoft Dynamics GP (Archived)

Analysis Cubes-Unhandled object exception: Microsoft Excel cannot access the file

(0) ShareShare
ReportReport
Posted on by MansoorN 115

I just installed analysis cubes, now I am trying to create PivotTable Reports through GP, Microsoft Dynamics GP>Tools>Analysis cubes>create PivotTable Reports. I am getting the following error message when try to save report. I am using GP2010. what is the resolution to this issue. I cannot seems to figure out how to resolve this issue.

"Unhandled object exception:
Microsoft Excel cannot access the file 'C:\Program Files (x86)\Microsoft Dynamics\GP2010\0DD50100'. There are several possible reasons:• The file name or path does not exist.• The file is being used by another program.• The workbook you are trying to save has the same name as a currently open workbook.
  EXCEPTION_CLASS_OBJECT_EXCEPTION

ExceptionSubClass:-2146827284 "

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    neilsensmith Profile Picture
    neilsensmith 60 on at

    Have you tried just connecting to your cube through a Pivot Table in Excel?  I've found this to be much easier than creating them through this window in GP.  To do this from Excel do the following:

    1. Click Insert in the Ribbon and select Pivot Table.

    2. Choose 'Use External Data Source

    3. Since this is the first time doing this you'll need to create the source so click 'Browse for More'.

    4.On the Select Data Source window click 'New Source'

    5. You should now be in the Data Connection Wizard.  Click on Microsoft SQL Server Analysis Services and select 'Next'.

    6.Enter the server name where the cubes were installed and the proper authentication.  I'd recommend Windows Authentication.  Click Next.

    7.You should now see the list of the GPcubes.  Pick the one you want to use and then Finish.

    You should now be in a Pivot Table in Excel looking at the GP cube you selected.  Next time you want to report on the same cube you'll just need to do steps 1 to 3.

  • MansoorN Profile Picture
    MansoorN 115 on at

    Neilsen,

    your proposed solution worked and I think it is much easier as you said in your answer. Thanks for your help. does that feature worked at all through GP  Microsoft Dynamics GP>Tools>Analysis cubes>create PivotTable Reports?

  • jalegria Profile Picture
    jalegria 5 on at

    Hi Neilsen,

    Is there any other way you know how to get rid of the error message? On the user point of view, this error should also be fixed GP. Any update on this?

    Thanks and regards.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans