Exclude a column from a table calculation
 

Hi,

Is there a way to exclude a column from a table calculation by "hiding" it?
I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are needed.

It's like saying, do the calculation including the data in Column A or exclude them.

A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to do the same in a table.

Thanks
Alex

Exclude a column from a table calculation
 

Try this, it should leave E column unchanged.

Range("A2:D100, F2:G100").Calculate

Be sure you have Calculation in Tools Options set to Manual and the Iteration box unchecked.


Regards
Robert McCurdy

"Metallo" wrote in message ...
Hi,

Is there a way to exclude a column from a table calculation by "hiding" it?
I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are
needed.

It's like saying, do the calculation including the data in Column A or exclude them.

A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to
do the same in a table.

Thanks
Alex


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 28/06/2004

Exclude a column from a table calculation
 

Robert,

It does not work.
I went to tools, options, set calculation to manual and iteration was already unchecked.
Then I highlighted the Columns I want in the calculation, press F9 but nothing happens.


Also, I'd like the column which I want to exclude to be hidden, but maybe I can do this after your formula will work??

thanks
Alex

"Robert McCurdy" wrote:

Try this, it should leave E column unchanged.

Range("A2:D100, F2:G100").Calculate

Be sure you have Calculation in Tools Options set to Manual and the Iteration box unchecked.


Regards
Robert McCurdy

"Metallo" wrote in message ...
Hi,

Is there a way to exclude a column from a table calculation by "hiding" it?
I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are
needed.

It's like saying, do the calculation including the data in Column A or exclude them.

A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to
do the same in a table.

Thanks
Alex


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 28/06/2004

Exclude a column from a table calculation
 

Can anybody reply, please?

Alex

"Metallo" wrote:

Robert,

It does not work.
I went to tools, options, set calculation to manual and iteration was already unchecked.
Then I highlighted the Columns I want in the calculation, press F9 but nothing happens.


Also, I'd like the column which I want to exclude to be hidden, but maybe I can do this after your formula will work??

thanks
Alex

"Robert McCurdy" wrote:

Try this, it should leave E column unchanged.

Range("A2:D100, F2:G100").Calculate

Be sure you have Calculation in Tools Options set to Manual and the Iteration box unchecked.


Regards
Robert McCurdy

"Metallo" wrote in message ...
Hi,

Is there a way to exclude a column from a table calculation by "hiding" it?
I could simply delete all the numbers in the column, but I want to have the possibility to get the numbers back, in case they are
needed.

It's like saying, do the calculation including the data in Column A or exclude them.

A bit like hiding part of the source data in a chart, if you do that, the hidden part will not show in the chart, well I want to
do the same in a table.

Thanks
Alex


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.712 / Virus Database: 468 - Release Date: 28/06/2004