| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Working with a large file, calculating after every little change
I am working with a large excel file and after every change I make, excel
turns my cursor into the hourglass and calculates for a too long....Is there any way I can work faster and have it calculate when I want it to? |
|
#2
|
|||
|
|||
|
hi,
yes. on the toolbar go.... toolsoptionscalculation tab check manual. but remember you are in manual mode. the sheet will not calculate unless you hit Key F9. regards FSt1 "brantty" wrote: I am working with a large excel file and after every change I make, excel turns my cursor into the hourglass and calculates for a too long....Is there any way I can work faster and have it calculate when I want it to? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
| Filter not working in a protected file | Excel Worksheet Functions | |||
| Sort a large file then sum like values... | Excel Discussion (Misc queries) | |||
| Unable to create any link/hyperlinks in a particular excel file | Excel Discussion (Misc queries) | |||
| How can I open a large Excel file with more than 65536 rows? | Excel Discussion (Misc queries) | |||
Linear Mode
