Excel 2007 : Finding a Data Table

[heski]

Hi,

An excel file (2007) of mine was modified by someone else, and now when it finishses calculating it says 'Data Table' in the bottom bar and I am unable to process.

It appears that it may be processing a data table.

Is there any way of viewing or finding data tables?

Thanks,

Heski

[jgoodhand]

Did you ever resolve this problem? I have the same one...

[jgoodhand]

I figured out a solution, I thought I'd post it for future users.

I had the problem of data tables which were recalculating during every iteration of a macro and it really slowed me down.

I used the 'Find' function under find and replace drodown menu in the 'home' ribbon of Excel 2007. (I think it's in 'edit' menu on older versions)

I looked for the word TABLE and found the cells I was interested in. Then I deleted only the cells containing the word TABLE and left the rest in case I want to create the table again.

Cheers