I have an excel files that contains many formulas so while opening the file it is taking time so let me know the solution
Excel file taking Time to Open
-
Sholtan -
March 29, 2017 at 9:17 PM -
Thread is marked as Resolved.
-
-
-
Re: Excel file taking Time to Open
formulas = manual
-
Re: Excel file taking Time to Open
How to do it what is the vba code
Plz Let me know -
Re: Excel file taking Time to Open
search set calculations to manual vba
-
Re: Excel file taking Time to Open
In simple language is there any vba code to do this or in excel we have the option to do the same
-
-
Re: Excel file taking Time to Open
yes there is vba code to do this. There is also a way to do it in an excel file.
-
Re: Excel file taking Time to Open
-
Re: Excel file taking Time to Open
Plz let me know both the way
-
Re: Excel file taking Time to Open
-
Re: Excel file taking Time to Open
Thnx Pal
-
-
Re: Excel file taking Time to Open
My condition- I have excel file that contains lots of formula so while opening the file it is taking lots of time So that's why what i want is whenever I open the excel file it should turn to manual calculation so that it can open fast and when it opens turn it into automatic calculation I need the vba code only
-
-
Re: Excel file taking Time to Open
Thnx pike
-
Re: Excel file taking Time to Open
Pike one more thing i also need a code to turn manual calculation to automatic
calculation -
Re: Excel file taking Time to Open
Don't see the point of either for opening a file. What's the file size? do you need to run a code cleaner to reduce the file size? , is it full of conditional formatting or coloured cells?, what you computer are running ram ect.. and are you opening it over a network?
I have extremely large files which are full of excel formulas to crunch a lot of data and don't have any problem opening within a second or three. -
-
Re: Excel file taking Time to Open
I am starting new thread close this thread i got a new plan i hate mistakes pike so i have a new plan
-
Re: Excel file taking Time to Open
Ok .. you can attach the workbook if you like
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!