Forum

Excel Question for a Combined report 3 Replies

Started by Meg McDonald in General. Last reply by Jim Smith 11 hours ago.

Add In: ExtendFormulaeToUsedRows 1 Reply

Started by Riekie Roux in General. Last reply by Jim Smith 11 hours ago.

Access Denied on Function 1 Reply

Started by Collington Rowe in Sage 300 ERP Intelligence Reporting. Last reply by Feroz Ally yesterday.

New to this forum 8 Replies

Started by Paula Park in Sage 100 and 500 ERP Intelligence Reporting. Last reply by Paula Park on Thursday.

Latest Activity

Profile IconBarbara Willis, Cleberton Roberto Antunes, Hayley Newton-Holroyd and 2 more joined The Sage Intelligence Community
5 minutes ago
Jim Smith replied to Meg McDonald's discussion Excel Question for a Combined report
"When you first save your template for your file, you are given a choice - "There are Pivot Tables in this workbook that use the 'Save Data with Table Layout' option. This can make your reports very large and is not recommended. Do you…"
11 hours ago
Jim Smith replied to Riekie Roux's discussion Add In: ExtendFormulaeToUsedRows
"You could probably record a macro to change the format of the cells in the column where the formula is, or create a macro that copies all of the contents of the data sheet to another sheet with only the values. Why do have an issue with the formulae…"
11 hours ago
Riekie Roux posted a discussion

Add In: ExtendFormulaeToUsedRows

Hi,I am using the ExtendFormulaeToUsedRows formula and want to replace the Formulae with Values.  I have selected "YES" on the add in setup.  However when I run out the report, all the formulae is still there.  It looks as if only the 1st column of my add in replaced the formulae with values.  All other subsequent columns still have the formulae in.How do I get it to replace all the formulae with values, for the whole formula range of my add in?See More
20 hours ago
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service