Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data tables
Hi,
I have two questions regarding data tables. 1. I have a 1-D data table that calculates about 50 formulas for me as a parameter is swept over about 100 values. I want to look at the results of this table under two conditions, say Temperature=Hot and Temperature=Cold. Is there a way I can make a copy of the table and instruct for the first table to use Temperature=Hot and for the second one to use Temperature=Cold. [Note a 2-D table is not what I want] 2. Whether my fist question above is possible or not, is there a way I can disable calculation of one table while letting the everything else on the sheet/workbook (including any other tables) active as normal? I want to speed up execution but I don't want to delete the table as I will need it again. Thanks in advance, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation and vlookup over 12 tables of data | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
PLEASE ANYONE ... DATA IMPORT EXTERNAL DATA - WEB TABLES | Excel Discussion (Misc queries) | |||
DATA > TABLE -- 2 variable data tables? | Excel Worksheet Functions | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) |