Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
High CPU when editing fields
Hi,
We are using excel 2003. on Window XP Professional When one of our employee's edits a cell by clicking "F2" and "Enter", the cpu of the excel.exe file goes spikes to %70 everytime slowing down the computer. The file is located on his computer and not the network. I had shut down McAfee virus software which I thought maybe scanning it without success. Any thoughts? Thanks. Mitch |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
High CPU when editing fields
It sounds like modifying the cell is causing Excel to recalculate. Depending on
the complexity of the file, recalculation could take a while. What happens when you set calculation to manual in ToolsOptions? -- Regards, Fred "mitch" wrote in message ... Hi, We are using excel 2003. on Window XP Professional When one of our employee's edits a cell by clicking "F2" and "Enter", the cpu of the excel.exe file goes spikes to %70 everytime slowing down the computer. The file is located on his computer and not the network. I had shut down McAfee virus software which I thought maybe scanning it without success. Any thoughts? Thanks. Mitch |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
High CPU when editing fields
When I set it to manual, the cpu goes very low which is a quick resolve. Is
there a setting on the computer or excel that can some how reduce the cpu and keep the employee on automatic? It has been a bit difficult for the guy. Could there be something in the operating system that maybe interfering? Mitch "Fred Smith" wrote: It sounds like modifying the cell is causing Excel to recalculate. Depending on the complexity of the file, recalculation could take a while. What happens when you set calculation to manual in ToolsOptions? -- Regards, Fred "mitch" wrote in message ... Hi, We are using excel 2003. on Window XP Professional When one of our employee's edits a cell by clicking "F2" and "Enter", the cpu of the excel.exe file goes spikes to %70 everytime slowing down the computer. The file is located on his computer and not the network. I had shut down McAfee virus software which I thought maybe scanning it without success. Any thoughts? Thanks. Mitch |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
High CPU when editing fields
There won't be anything in the operating system interfering with Excel. You must
have a lot of calculations that Excel must do. Excel automatically goes into smart Recalc mode, which recalculates only what's necessary. Do you have a lot of Sumifs or Vlookups? You either need to find whatever it is which is causing Excel to take so much time to recalculate, use manual recalc, or put up with the auto recalc time. -- Regards, Fred "mitch" wrote in message ... When I set it to manual, the cpu goes very low which is a quick resolve. Is there a setting on the computer or excel that can some how reduce the cpu and keep the employee on automatic? It has been a bit difficult for the guy. Could there be something in the operating system that maybe interfering? Mitch "Fred Smith" wrote: It sounds like modifying the cell is causing Excel to recalculate. Depending on the complexity of the file, recalculation could take a while. What happens when you set calculation to manual in ToolsOptions? -- Regards, Fred "mitch" wrote in message ... Hi, We are using excel 2003. on Window XP Professional When one of our employee's edits a cell by clicking "F2" and "Enter", the cpu of the excel.exe file goes spikes to %70 everytime slowing down the computer. The file is located on his computer and not the network. I had shut down McAfee virus software which I thought maybe scanning it without success. Any thoughts? Thanks. Mitch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing fields in bulk | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
How do I lock some fields but allow editing for others in excel | Excel Discussion (Misc queries) | |||
Pivot table # of fields | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) |