How to select/calculate entire sheet excluding tables?

**Kelvin Stott** · 11-03-2010, 02:19 PM

Hi,

I've been struggling with this all day...

Is there a term I can substitute below to recalculate the active sheet, excluding any data tables?

Please Login or Register  to view this content.

**shg** · 11-03-2010, 03:57 PM

Dunno if this works or not:

Please Login or Register  to view this content.

**Kelvin Stott** · 11-03-2010, 04:13 PM

Thanks, but unfortunately this didn't work: it did the full calculation including the tables.

**shg** · 11-03-2010, 05:37 PM

How about this (untested):

Please Login or Register  to view this content.

If not, you can calculate around the table,

Please Login or Register  to view this content.

I don't have another suggestion

**romperstomper** · 11-03-2010, 06:31 PM

Once again:

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this