Excel is getting hanged

[vijavad]

Hi All

I have a normal excel sheet without any macros . But for every single click the excel is getting hanged and shows " Not responding " and comes back again.

I am facing very difficulty. Can anybody help me what might be the problem .

 

[Joe4]

Please tell us more about this sheet, such as:
- Do you have any links or hyperlinks in it?
- How much data is in it?
- Do you have a lot of formulas (if so, about how many)?

 

[vijavad]

Hi Joe

Yes i have formulas, links , Pivot tables in the other tabs as well .
Formulas may be 5 to 6 not more than that. And i have 18 tabs in the worksheet

 

[Joe4]

What exactly are you linking too?
How many linking formulas are there?

The data source that you are linking to may be slowing things down, especially if it is constantly trying to refresh.