"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…"
"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…"
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