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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Excel Budget Wizard import issues

(0) ShareShare
ReportReport
Posted on by 45

Hi,

I am noticing issues importing budgets using excel when the client has excel 2007 on their workstation.  What happens is the budget import when you select which file, it prompts you first with "do you want to save your changes to budget xyz.xls?".  This happens even when excel is closed on the machine I am working on.  If I say yes or no, either response then prompts me with "are you sure you want to exit the excel import wizard?".  Of course I say no, then I am able to select which worksheet my budget is on, as normal, and click Finish.

Next after clicking Finish, it asks me "budget xyz.xls is already open, reopening it may cause issues" (something along those lines).  I say Yes, (as in, yes, re-open the spreadsheet) and finally it imports.

Then when I'm done, excel is not open but the excel.exe process is running in task manager and the budget file I imported from is locked, it thinks the file is still open, until I kill the excel process manually.

Second and related issue, if I have other excel workbooks open when I import, when it is done importing, excel is hidden, ALL of the workbooks are locked as already open and non-recoverable.  I re-open Excel and those workbooks do not come up for recovery.

It seems isolated to Excel 2007.  Nothing on partnersource about it.  Don't want to waste a support case on it, in case they decide it's not a bug! 

Anyone else with the same or a workaround to this?

*This post is locked for comments

I have the same question (0)
  • Ellen Ryan Profile Picture
    700 on at

    You are not alone!  I've been dealing with this since we went to GP in July.  I've learned to close all of excel before importing so it does not affect other files.  But it still leaves the issue of not allowing me to re-open the budget import file unless I shut down my computer.

    Whatever information you find out about this, can you share with me?!

     

    Thanks

    Ellen

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans