Report Exporting to Excel (want to change white background!)

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
EEAD
Experienced Cover User
23 Posts
Experienced Cover User
Australia
Experienced Cover User

23Posts

3Kudos

0Solutions

Solved: Go to Solution

Report Exporting to Excel (want to change white background!)

Using MYOB AccountRight Premier.

 

When exporting report to excel, I am facing the following issues and want to change them.

Please advise how to achieve these?

 

1. White background

 

    Exported excel shows white back ground. This looks nice but difficult to see line items witout any cell lines.

    I guess many accountants feel same but how to change this? I tried cell formatting but could not change them.

 

2. Text rather than numbers

 

   All cell informaiton was exported as text even only number cells.

   Most annoying thing is negative numbers are exported as #### cr rather than simple negative numbers.

   This makes difficult to manage to alter and edit as reports.

   Any solutions?

 

Thanks for your help in advance!

5 REPLIES 5
EEAD
Experienced Cover User
23 Posts
Experienced Cover User
Australia
Experienced Cover User

23Posts

3Kudos

0Solutions

Report Exporting to Excel (negative number exported as text ## cr rather than number!)

Using MYOB AccountRight Premier.

 

When exporting report to excel, I am facing the following issue and want to change them.

Please share your idea?

 

Text rather than numbers

 

   All cell informaiton was exported as text even only number cells.

   Most annoying thing is negative numbers are exported as #### cr rather than simple negative numbers.

   This makes difficult to manage to alter and edit as reports.

   Any solutions?

 

Thanks for your help in advance!

Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Accepted Solution Solved

Re: Report Exporting to Excel (want to change white background!)

Hi @EEAD , what version of Premier are you using? And what report are you running?

 

Version 19 created Excel output for the GL Summary report with negatives as "1234.56cr", but I think AccountRight lIve does this correctly. 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

EEAD
Experienced Cover User
23 Posts
Experienced Cover User
Australia
Experienced Cover User

23Posts

3Kudos

0Solutions

Re: Report Exporting to Excel (want to change white background!)

Hi @Mike_James ,

 

As you noted, I know the AccountRight lIve (v2021) can display it as negative numbers.

Since I have a couple of company file which cannot go online due to our licence, I just wanted to know any other way, but thank you!

 

I am sitll looking to change the background from white to none, so if you know any solution, your input is highly appreciated.

Mike_James
Ultimate Partner
5,839 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,839Posts

1,080Kudos

755Solutions

Re: Report Exporting to Excel (want to change white background!)

Hi @EEAD , you originally said that you wanted the cell borders back. This is an Excel setting under File, Options, Advanced, Display Options for this worksheet, and tick the option to show gridlines. You can edit the source template as before, and change then save it. You will get gridlines across all the transaction rows. 

 

Note: Be careful to close your edited template before sending any MYOB report to Excel, or your report will appear in the actual template!

 

I use an Excel macro to help with changing numeric cells containing "cr" to negative numbers.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

EEAD
Experienced Cover User
23 Posts
Experienced Cover User
Australia
Experienced Cover User

23Posts

3Kudos

0Solutions

Re: Report Exporting to Excel (want to change white background!)

Hi @Mike_James ,

 

Thank you again.

I believed this was special setting of the system but it was simple excel setting.

 

I really appreciated your input and help!

 

 

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post