Frozen Excel Spreadsheets

V

Virginia H

New Member
Joined
May 19, 2011
Messages
3
I use Excel 2003. Recently my spreadsheets freeze up after I run a pivot table and start copying and pasting different parts of the pivot table into another worksheet. If I email it to someone else, they can navigate the spreadsheet. I cannot activate any of the sheets and sometimes the cursor is frozen on one cell too. Any ideas how to "unfreeze" the sheet?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
Duplicate

Virginia,
There could be lot of reason that your spreadsheet frozen - how big is your pivot table, how much data must Excel recalulate after each pasting.
Try to switch off Automatic Recalculation that may help.
 
Upvote 0
Thanks. I will try that. My spreadsheet is large. Probably 25,000 rows and 14 columns on this one. Maybe when we upgrade to MS Excel 2010, I will not have the problem.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Frozen panes scrolling a whole 2nd spreadsheet in the one pane. On a mac
Replies
0
Views
318
sambee66
S
Z
  • Solved
Frozen screen
2
Replies
11
Views
587
zelarra
Z
T
  • Question Question
Excel Freezing Issue
Replies
2
Views
334
Teegrubb
T
D
  • Question Question
Pivot Table Refresh Issue
Replies
7
Views
892
Alex Blakenburg
A
E
  • Question Question
Stumped Trying to Find a Table Referenced by Pivot Table
Replies
3
Views
462
Elfear73
E

Forum statistics

Threads
1,224,603
Messages
6,179,850
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top