I am working on an application where I need to populate huge data in grid. User can export this data to excel file and sometime user can download this data into excel file as well
Some time I am getting error while opening excel file.
“We found a problem with some contain in excel file.”
Team suggested to use macro in Excel, after implementing this I can open file without any error message.
But I did not understand how dose macros solved the problem and why my team suggested to use macro in Excel
Appreciate your inputs.