Excel 2010 - Open excel file
Posted on 2011-09-19
Can you please advise we have an excel file on the server which seems very hard to open, because someone put into it some complex vlookup formula and all the time it is just calculates at the opening.
Is there maybe some method that the Excel would open a file with ignoring all the formulas inside? Because in this way I can not open the file.
Anyway there is a question at the beginning that should be the workbook updated, but inspite of the no it is just calculating