I have a database which exports data to an excel file for viewing summary data. The excel spreadsheet has various tabs.
All of it works perfectly, but I would like to be able to see the excel file, move through tabs etc from within the db. I don't want to edit/change the ss, just to be able to see the summary data in all the tabs. Is this possible?
(I used to have access reports that mirrored the ss layout and summary data, but since pivot tables are no longer a feature in access, I have to use the ss instead, and I would like to be able to make it as user-friendly as possible for non tech users.)