Strange Slow Downs in Excel Sheet

[cdnqte]

I have a spreadsheet that has approximately 930 rows and 18 columns on one sheet. For some reason, when it gets to about the 700TH row, it slows right down to a crawl when trying to scroll through the data; when I highlight cells to copy or past, it distorts the view, appearing to split cells, etc. There is only one column with a very simple (x*y) formula.

I cannot seem to find what would be causing this to happen - would anyone have any suggestions as to what to look for?

 

[Datsmart]

Take a look at this post. Similar issue.
Try his suggestions.
http://www.mrexcel.com/board2/viewtopic.php

Edit: correct link
http://www.mrexcel.com/board2/viewtopic.php?p=1115162

 

[erik.van.geit]

Hi,

John, check your link
perhaps this will help
http://www.decisionmodels.com/optspeed.htm

your workbook might be corrupt: perhaps rebuilding it from scratch could help

kind regards,
Erik

 

[Datsmart]

Sorry for the bad link. Here is the one I was after.
http://www.mrexcel.com/board2/viewtopic.php?p=1115162