LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default More Data Table Problems

Some of my 2-dimensional data tables stopped working when I made some
changes to a file. Am I right that the column and row input row variables
CAN be used in the row across the top and column down the side? That is,
none of these needs to be a number?

For example, I have a 5X5 data table with the row variable being cell D4,
and the entries across the top are d4-100,000, d4 - 50,000, d4, d4+50,000,
d4 +100,000. Is this legal? Strangely, a value does appear beneath the 4th
entry (d4+50,000), but not below any of the others - they all show "#Value".
I'm talking about the first row here and coincidentally, the column entry is
a number there, whereas for the other rows, they are equations.

In the 2nd row, they all show #value. If I change one of the column
scenarios to be tied directly to the column input variable, it does not help
and, from the answer showing in the top left corner of the data table, I
know this does have a real answer.

Do data tables have known problems? It seems like they are finicky?

I tried erasing it and copying it in from the older file that did work, but
it did not copy the data table matrix formulas. Then I just tired redoing
the data table, but that did not help either.

Thanks!
Dean


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Problems [email protected] Excel Worksheet Functions 0 December 21st 06 03:15 PM
large data file problems - pivot table with vba [email protected] Excel Programming 0 July 29th 05 02:31 AM
large data file problems - pivot table with vba [email protected] Excel Programming 0 July 29th 05 02:30 AM
Pivot Table problems Randy Starkey Excel Programming 2 March 31st 05 01:50 AM
I am having problems creating pivot table of data wyman Charts and Charting in Excel 1 January 12th 05 05:17 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"