Hi,
I have lots of formula in 1 sheet which is linked with another sheet in same file.
Whenever i update 2nd sheet in which data is there, it hangs always due to lots of formula in sheet1.
can i stop this automatic linking and use any option in excel to link manually.
so that after updation data in 2nd sheet, i use that option to link.
rgds
Maybe you can put recalculate on manual.
Excel 2007 => formula => calculate
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Amit,
You can put the calculation to manual mode... and press Shift + F9 to calculate just the current worksheet and then calculation update will not happen for entire workbook. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
or
Or you can go to File-option-advanced-scroll down look for when calculating this workbook ="Update links to other workbook" untick it.can i stop this automatic linking and use any option in excel to link manually
then just below that under general tick the "Ask to update automatic links"
Then you can do a manual update link -go to Data menu- external links - edit links - udpate
Regards,
vladimir
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
HI,
Its working, pls tell how can i put this calculation option in a button which i will insert in Cell A1
Originally Posted by dilipandey
---------- Post added at 06:22 AM ---------- Previous post was at 06:20 AM ----------
How can i put this calculation option in a button and how can i insert a button in cell A1
This is just a switching on / off of auto calculation mode... do you need button for this ?
I guess you can use the shortcut keys (hot keys) :-
To activate manual mode:-
Alt + t + o
down arrow
Alt + M
Enter
to activate auto calc mode:-
Alt + t + o
down arrow
Alt + A (only this step changes)
Enter
Regards,
DILIPandey
<click on below 'star' if this helps>
Yes i need button, i have insert button but how can i link formula calculation sheet tab in this button
Re: Link Stop formula
Solved--i put activesheet.calculate in button coding...thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks