GP Budget Export not completing

(0) Share

Report

Posted on by ARand

122

I have a client that is on GP 2013 and they have about 75000 accounts and growing. They have exported budgets to Excel before but one of the new ones is stopping at 32767. It looks like it completes the process in GP but it only sends out so many records to Excel. We are not sure why it is stopping at that number for multiple people. Is there somewhere I can set this number to a higher number in Excel?

*This post is locked for comments

All responses (4)

Answers (0)

Rosemary 10 on at

Like (0)

Report

RE: GP Budget Export not completing

Hi,

https://support.office.com/en-us/article/Excel-specifications-and-limits

Take a look at this document.

Regards

Rosemary
26P2ER 1,775 on at

Like (0)

Report

RE: GP Budget Export not completing

Armand:

I recommend contacting MS support.

Will try to recreate this sometime over the next few days.

Curious, did you try importing more than 32767 rows into a new budget?

Best of luck

Ven
ARand 122 on at

Like (0)

Report

RE: GP Budget Export not completing

Thank you for the info but they are on GP 2013 R2. Any other suggestions?
Suggested answer

26P2ER 1,775 on at

Like (0)

Report

RE: GP Budget Export not completing

Hello ARand:

Experts have solved this issue. Read here

https://community.dynamics.com/gp/f/32/t/120293

It appears you may need to apply SP to GP2013.

Best of luck

Ven