| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't choose an imput cell for my data table in another worksheet
I have a data table which evaluates a formula, but I want to keep the imput
data in another worksheet. Excel does not calculate the data table and states it is an invalid imput data. I know it is the imput data because I have done the same data table with the imput data in the same worksheet. Version : Excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't choose an imput cell for my data table in another worksheet
Think that is a constraint when using Data Table.
I'd live with it, get the table up on the same sheet, then just "mirror" the table/parts of it elsewhere on other sheets via simple link formulas if needed. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Rick" wrote: I have a data table which evaluates a formula, but I want to keep the imput data in another worksheet. Excel does not calculate the data table and states it is an invalid imput data. I know it is the imput data because I have done the same data table with the imput data in the same worksheet. Version : Excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two-imput data table | Excel Worksheet Functions | |||
| How do I choose a cell colour, without it being tied to the data? | Excel Discussion (Misc queries) | |||
| Data Validation, Invalid Data Imput | Excel Discussion (Misc queries) | |||
| can not imput data on saved worksheet | Excel Worksheet Functions | |||
| Is there a way of making data imput in to a cell mandatory before. | Excel Worksheet Functions | |||
Linear Mode
