Excel 2010 - Open excel file
Dear Experts,
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
thanks,
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
thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks the advices, theoretically at the opening should be Shift or Control to keep pressed? Basically tried both but that did not help.
So far my best attempt was following celazkon's launch Excel, Select/Open file, after I clicked to Open in Protected view. With this the file is opened without calculation. But after I would need to save this file, so at least do Copy all cells and Paste Special/Values to remove everything from it, but for this would be needed to click on Enable editing.
And so when clicking on this Enable editing, it is starting again the calculation and freeze.. :-)
So far my best attempt was following celazkon's launch Excel, Select/Open file, after I clicked to Open in Protected view. With this the file is opened without calculation. But after I would need to save this file, so at least do Copy all cells and Paste Special/Values to remove everything from it, but for this would be needed to click on Enable editing.
And so when clicking on this Enable editing, it is starting again the calculation and freeze.. :-)
ASKER
The strangest for me that why it is calculating if I click on Don't Update button.
ASKER
Okay I was able to do with this tactic
1) Open Excel, going to Formulas/Calculation Options/Manual
2) Open file in Protected mode
3) Enable editing
4) Copy all cells, Paste Special as values
5) Save the file to hard drives.
I have also identified that someone did a vlookup from her C:\Temp directory file, I assume also the network slowness was factor in this slow calculation.
Thanks the advices so closing the topic
1) Open Excel, going to Formulas/Calculation Options/Manual
2) Open file in Protected mode
3) Enable editing
4) Copy all cells, Paste Special as values
5) Save the file to hard drives.
I have also identified that someone did a vlookup from her C:\Temp directory file, I assume also the network slowness was factor in this slow calculation.
Thanks the advices so closing the topic
Did you try my suggestion? Press and hold your Ctrl key and then double click the file to open it in safe mode.
ASKER
Yes I have tried but for me with holding the Ctrl, even the file is not opening.
With holding the Shift yes it is opened, but in state of calculating so freezed
With holding the Shift yes it is opened, but in state of calculating so freezed
gowflow