x Want to participate? Join the group to interact

Sage CRM

Welcome to the Sage CRM Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

General Discussion Excel export has hidden columns

State Not Answered
Replies 3 replies
Subscribers 75 subscribers
Views 422 views
Users 0 members are here

Browse Forums

105

topics

32

replies

General Discussion

6k

topics

18k

replies

Excel export has hidden columns

Posted By Anthony Volpe 4 months ago

Using Sage CRM 2023 R2 reports are now exporting 'blank' if exported to XLSX. All of the data is in hidden columns. Any ideas?

Parents

0 Ocean Helberg 4 months ago

Hi Anthony, the column width might be set to null.

Within Excel, on the Home menu ribbon, select Format and then Column Width, should it be null, increase the value to above 5.

Could you confirm if this is a new installation or an upgrade?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Ocean Helberg 4 months ago

Hi Anthony, the column width might be set to null.

Within Excel, on the Home menu ribbon, select Format and then Column Width, should it be null, increase the value to above 5.

Could you confirm if this is a new installation or an upgrade?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Anthony Volpe 4 months ago in reply to Ocean Helberg

This is an upgrade. Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ocean Helberg 4 months ago in reply to Anthony Volpe

We can replicate the issue and currently working on a resolution.

Please use the below workaround for the time being:

Within Excel, on the Home menu ribbon, select Format and then Column Width, should it be null, increase the value to above 5.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel