Excel pivot table not responding

Hi, you are correct (as is Richard). I have a table and this is what is causing the issue. I actually ran the tool your link refers and I still have the same issue. Every time I click on a cell or move from cell to cell excel stops responding or runs very slowly. I trimmed the table down to 5 rows and removed all other tabs and I still have the same issue. The file is large at just over 1 meg (well large considering there are only 5 rows and 20 columns). Does this shed nay light on what the issue could be?

Richard

Hi, END+HOME took me to XFD so as suggested I deleted these and also deleted rows up to 1048576. Tried END+HOME again and it went to the end of the table. So great result. I saved the file and reopened. This reduced the file about 100k (I used a copy of the full workbook). So now down to 1,256 from 1,350.

I reopened the sheet and then removed all formatting. The saved it again and reopened. It's a bit quicker however still very slow to move from cell to cell. IS there anything else you think I should try? I feel we are getting close to a solution. Thanks for your advice.