I am generating an excel .xslx file with 8 tabs, in several of them I am adding formulas, which are called between the different tabs, when creating the report in one of those tabs it generates the system memory exception message and it does not finish generating the report, my question is how many formulas can be added to an excel file? NOTE: the process in the task manager reaches 1.5 gb and closes the task
How many formulas can be added to an excel file without increasing the RAM too much and avoiding the system.memory.exception message?
The formulas are written as simple String objects, so I doubt they are the real cause of your issues.
Can you send us the stack trace of the exception?
Also, can you send us a Visual Studio project that reproduces your issue so that we can investigate it?