+ Reply to Thread
Results 1 to 2 of 2

Spreadsheet Corruption

  1. #1
    Registered User
    Join Date
    02-04-2011
    Location
    Siuox Falls, South Dakota
    MS-Off Ver
    Excel 2007
    Posts
    1

    Spreadsheet Corruption

    I have an issue with Excel 2007. I have been told that my spreadsheets are growing exponentially, and I had no idea it was happening. Apparently when I cut and paste, delete and use other basic functions, this data is still being stored in the background of the spreadsheet causing it to grow at alarming rates. This is causing the spreadsheet to "freeze" and in worst case scenarios, causing the computer to lock up.
    Does anyone have any ideas why this is happening, and how to prevent it from happening?
    Thanks,

  2. #2
    Forum Contributor TechRetard's Avatar
    Join Date
    06-14-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Spreadsheet Corruption

    just off the top of my head w/o seeing your sheet --- If you have very large spreadsheets with formulas, every time excel autosaves it will take freeze for some time, depending on the size. Also, if you have thousands of rows with multple columns with formulas, anything that triggers a calculation will force all calculations on the sheet to run. If you don't need the formulas anymore, try copy and pasting values so it gets rid of the formulas and just keeps the values.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1