Skip to Main Content
Sage 200 UKI Ideas Portal
ADD A NEW IDEA

Excel

Showing 7

Move away from CSV imports & introduce Excel imports

It would be more efficient to move away from using CSV file imports & instead enable Excel file imports as this would remove the step of saving as a csv file, it would also reduce the chances of introducing data errors on import when a user op...
Guest over 7 years ago in Excel 0 Idea Accepted - Gauging Support

Data to Excel to send Text Fields and Expressions to Excel

Sage support advised on an issue I had where the customer was sending details to Excel via Data to Excel - where text fields and Expressions didn't show on the output: When using the 'Data to Excel' option, any expression created using multiple fi...
Gary Butler almost 2 years ago in Excel 0 Idea Accepted - Gauging Support

Data to Excel to show Returns/Credits as negative

Not sure if this is possible as Data to Excel dumps the data contained in a report to Excel from the table formatting and ignores formatting on the report, but it would be great if Credits and Returns would show as negatives when using Data to Exc...
Gary Butler over 4 years ago in Excel 2 Idea Accepted - Gauging Support

Data exports to go to the default Spreadsheet application

Sage appears to look for the excel executable to create data exports, rather than generating the data and allowing the OS to direct the file according to the users spreadsheet default. Version 12.00.0035
Chris Jones over 1 year ago in Excel 0 Idea Accepted - Gauging Support

Excel Addon - Please bring it back!

Please can the Excel Addon be made available again for 2016? It used to be such a handy tool when we were in 2011 to pull some data from Sage very quickly. Querying SQL is fine, but it requires some tech knowledge that not many staff have.
Guest about 7 years ago in Excel 0 Idea Accepted - Gauging Support

Data to excel to report same info as within the report as at present this is not the issue.

With reference to one of my Incident reference - 190318-E8924. (Still unsure why this needs to be an idea hub issue as well to me data to excel doesn't work as expected) When running a Sales invoices and credits notes summary and detailed report w...
Guest almost 7 years ago in Excel 0 Idea Accepted - Gauging Support

Export list view

Creates a new instance of Excel every time you export data. This means you cannot move a tab from one sheet to another and must copy the data to the first instance of excel and then shut down the second instance created by the export.
Guest about 9 years ago in Excel 0 Idea Accepted - Gauging Support