Excel not responding

[shahdelsol]

I created a workbook 3 years ago and since then each month I have been adding a new tab. I currently have about 36 tabs. All tabs are identical size which they are from A1 to AP69. Not every cell has data but most of cells has something in it so I don't think it is necessarily a big file. Every month I have been copying last tab or one of tabs to create a new tab and add new data. There hasn't been any problem until recently when I am trying to copy new tab and add to the end of tabs I get " Excel not responding" like there is lack of memory or something and goes for ever. One time I didn't cancel and let it go and finally after a few hours it created a new tab. My question is : Is this lack of memory? To me This is not a big file and I have only 36 tabs and tabs/sheets are not big file.

I have also hidden the rest of cells beyond A1 to AP69 and I don't know if this matters or not. My Excel is Home and business 2016 version. ​

Does anyone know why it takes this long?

 

[Peter_SSs]

Something to try would be to create a new workbook and copy your existing worksheets to the new workbook and see if the problem still persists in the new workbook.

 

[shahdelsol]

Thank you for quick response. First I tried to copy all tabs at the same time to new workbook. Same problem...excel not responding. I cancelled after a few minuets. Then I tried to copy only one tab to new workbook. Same problem. I haven't cancelled yet and as I am writing this it is not responding yet...about 5 minutes in it.

Something to try would be to create a new workbook and copy your existing worksheets to the new workbook and see if the problem still persists in the new workbook.

 

[Fluff]

When xl comes back up, on the sheet you are trying to copy, press Ctrl End. What cell do you end up in?

 

[shahdelsol]

Still hanging. How do I do this? Do I cancel it and ctrl End? Or should I wait until it is done which could take hours?

When xl comes back up, on the sheet you are trying to copy, press Ctrl End. What cell do you end up in?

 

[Fluff]

Up to you, but If it's already taken over 5minutes I'd tend to kill it.

 

[shahdelsol]

I killed it and reopened. After CTRL End I got Cell AP69 which is my last cell. remember I have hidden all cells beyond A1 to AP69.

Up to you, but If it's already taken over 5minutes I'd tend to kill it.

 

[Fluff]

Unhide all the columns/rows & try it again. Do you still endup on AP69?

 

[shahdelsol]

As matter of fact. I did before reading your response and I ended up in the last cell of workbook XFD1048576. This doesn't make sense. When I ctrl end shouldn't I land on the last cell with data? My data is on A1 to AP69. The rest of cells are empty. Now I think about it my last cell with data is L69 so technically I should land on L69. What do you think it is?

Unhide all the columns/rows & try it again. Do you still endup on AP69?

 

[Fluff]

You probably have hidden formats or data somewhere on the sheet.
Select all rows below your data & delete them (ie right click & delete) then do the same for the columns. Save the workbook & see where Ctrl End takes you.