1,075
Is it possible to create two excel reports using excel report builder(one for sales, another for financial) and merge the sheets together onto one book? Will the data be refreshable per sheet or does excel allow only one data connection per work book?
Thank you,
Mike
*This post is locked for comments
Hi Mike,
Yes, excel allows multiple connections per Excel Sheet. We can create a separate connection for each workbook in an Excel sheet.
However, you will need to manually merge the sheets after publishing. After publishing the reports, open the both reports in excel. Right Click on workbook name and use the Move or Copy Option in the workbook merge two excel sheets. This will also move the data connection of the sheet to destination excel sheet. You can see the connections on Data tab in excel sheet.
If you make any changes in reports in GP and re-publish them, you will need to merge the sheets again.
Rubal,
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
