Sage 100

Hi Rhonda- The only way that I have found that will work properly especially with multiple Tree formatting or multiple database consolidations, is to create a blank template in the Premium Report Manager, and copy the sheets from the old into the new. Its easiest if you just use the design function in the old to bring up the old template, instead of running it. I did try saving the entire old workbook template over the new Premium template, but it still errored. That might have been because the report in whole was pulling more than financial data for the designer. For non financial reports I found that you have need to recreate the container, the report layout, run the report then you can replace the sheets within the new template with the formatted worksheets from the old, sometimes replacing references of graphs and pivot tables to the new template if required.

Hi Rhonda- The only way that I have found that will work properly especially with multiple Tree formatting or multiple database consolidations, is to create a blank template in the Premium Report Manager, and copy the sheets from the old into the new. Its easiest if you just use the design function in the old to bring up the old template, instead of running it. I did try saving the entire old workbook template over the new Premium template, but it still errored. That might have been because the report in whole was pulling more than financial data for the designer. For non financial reports I found that you have need to recreate the container, the report layout, run the report then you can replace the sheets within the new template with the formatted worksheets from the old, sometimes replacing references of graphs and pivot tables to the new template if required.