I have an application in which user click on link and download excel with macros in zip folder. When user open excel the macros will run and populate the excel. Around 5 million records are available on multiple tab.
Now the requirement is to open the same report on excel online(Browser), weather user have access on office 365 or not, he should be able to open and edit the excel.
If user have office app installed, then it will ask user weather to open excel in app or to open app in browser.
What I have tried:
Tried share point but it due to high record it is giving error.