Small and medium business | Business Central, N...

Account Schedules exported to Excel - is there a column limit?

(0) Share

Report

Posted on by Marmeduke8

Good day Folks

When exporting the results to Excel of an account schedule after generating it via the Process / Overview functionality, is there a known column limit? I could have over 300 columns and before I set about defining the enoroums amount of columns needed, I'd rather know ahead of time if there is a limt when exporting the data to Excel.

Your assistance would be appreciated.

Thank you

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Account Schedules exported to Excel - is there a column limit?

Marmeduke,

I would use Jet reports to accomplish this.

Thanks,

Steve
Marmeduke8 on at

Like (0)

Report

RE: Account Schedules exported to Excel - is there a column limit?

Thank you Steve.

I'm thinking of guiding my client to use a different method of reporting as, even if we can sent it to Excel, it will be too cumbersome to work with there.

Apprecate your time.

Thank you
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Account Schedules exported to Excel - is there a column limit?

Marmeduke,

I can definitely say I have never had some many columns in producing an Account Schedule. I know Excel has total number of rows and columns on a worksheet 1,048,576 rows by 16,384 columns.

Thanks,

Steve