Most likely the issue is the worksheet structure/name: for Financial Reporting Excel templates, Microsoft’s documented process is to copy the generated worksheet and rename the copied/raw-data sheet to Data, not Output. Then you can rename/format the other worksheet as your presentation/report tab. When you upload the file through Update Excel template with data, the workbook should be closed, and when BC asks which worksheet to update, select Data. Also, don’t change the position/structure of the generated data area too much, because the row/column layout must still match the financial report definition. I would retest with a fresh template: create template → copy sheet → rename copied sheet to Data → rename original sheet for presentation → save/close → upload again.
Regards,
Oussama Sabbouh
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
8
Share
Report
All responses (
Answers (
