Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a user that has the following issue. In Excel, when sorting all the cells they get this warning "The operation you are about to perform affects a large number of cells and may take a significant amount of time to complete. Are you sure you want to continue?"

They have been using this spreadsheet this way for years and only now has this issue. Any thoughts?

share|improve this question
    
Is this workbook growing in size, or is there a cleanup on data every now and then? –  Terry May 24 '12 at 6:54
    
It keeps growing in size. –  Scott Felhofer May 25 '12 at 15:21
    
Then the message your user is getting is pretty obvious, your data has grown too large and needs more time computing changes. You can do 3 things: wait for the workbook to recalculate, rethink how you build up the workbook or consider an alternative for excel. –  Terry May 25 '12 at 16:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.