I have a workbook that uses a function called table(,cell).

I need to undertstand how that feature is used and how the table was set up.
Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement list.

Please help!

That sounds like a UDF or User Defined Function, ie something that someone
has written, not a built in Excel function.
Try hitting Alt and F11 together to open the VB editor and look in Sheet1,
Sheet2, This Workbook etc on the left.
Look for something that starts 'Function Table () or similar.
Copy and paste the code here and maybe someone will be able to help you with
it,
Regards,
Alan.
"Katie" wrote in message
...
I have a workbook that uses a function called table(,cell).

I need to undertstand how that feature is used and how the table was set
up.
Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement
list.

Please help!

No. There is information about the table feature. It is something that is
part of Excel, but does not work like regular functions.

I did find some sites, but don't understand enough to figure out how the
worksheet was put together originally.

here is a site I found that describes the table feature and function, if
that helps anyone understand what I want to find out.

http://support.microsoft.com/default...b;en-us;282851


Katie



"Alan" wrote:

That sounds like a UDF or User Defined Function, ie something that someone
has written, not a built in Excel function.
Try hitting Alt and F11 together to open the VB editor and look in Sheet1,
Sheet2, This Workbook etc on the left.
Look for something that starts 'Function Table () or similar.
Copy and paste the code here and maybe someone will be able to help you with
it,
Regards,
Alan.
"Katie" wrote in message
...
I have a workbook that uses a function called table(,cell).

I need to undertstand how that feature is used and how the table was set
up.
Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement
list.

Please help!

Yes, your right, it is a built in function. It's in the 'Data' toolbar. I've
been using Excel in a reasonably advanced way for years and I've never used
it, and I must confess ever heard of it!
There's an explanation of how it works he-
http://www.homeandlearn.co.uk/ME/mes8p1.html
I followed the tutorial and it does work, but I don't really think I'd ever
use it, it seems more trouble than it's worth. You may have trouble back
tracking your sheet however, I presume it's something that you've inherited.
There doesn't seem to be any way of seeing what the table refers to other
than checking each cell to see if it has a table reference in it, (like
{=TABLE(,B3)}). Hitting Ctrl and ' together will toggle the formulas on the
sheet (' is the key just below the Escape key), that may help,
Good Luck!
Regards,
Alan.

"Katie" wrote in message
...
No. There is information about the table feature. It is something that
is
part of Excel, but does not work like regular functions.

I did find some sites, but don't understand enough to figure out how the
worksheet was put together originally.

here is a site I found that describes the table feature and function, if
that helps anyone understand what I want to find out.

http://support.microsoft.com/default...b;en-us;282851


Katie



"Alan" wrote:

That sounds like a UDF or User Defined Function, ie something that
someone
has written, not a built in Excel function.
Try hitting Alt and F11 together to open the VB editor and look in
Sheet1,
Sheet2, This Workbook etc on the left.
Look for something that starts 'Function Table () or similar.
Copy and paste the code here and maybe someone will be able to help you
with
it,
Regards,
Alan.
"Katie" wrote in message
...
I have a workbook that uses a function called table(,cell).

I need to undertstand how that feature is used and how the table was
set
up.
Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement
list.

Please help!

Katie -

For some step-by-step examples of the Data Table feature, see Chapter 2,
Sensitivity Analysis Using Excel, available from the Chapters page at
http://www.treeplan.com

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Katie" wrote in message
...
I have a workbook that uses a function called table(,cell).

I need to undertstand how that feature is used and how the table was set
up.
Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement
list.

Please help!

'I have a workbook that uses a function called table(,cell).'
Forgot to mention, 'cell' is probably a named range.
Alan.
"Alan" wrote in message
...
Yes, your right, it is a built in function. It's in the 'Data' toolbar.
I've been using Excel in a reasonably advanced way for years and I've
never used it, and I must confess ever heard of it!
There's an explanation of how it works he-
http://www.homeandlearn.co.uk/ME/mes8p1.html
I followed the tutorial and it does work, but I don't really think I'd
ever use it, it seems more trouble than it's worth. You may have trouble
back tracking your sheet however, I presume it's something that you've
inherited. There doesn't seem to be any way of seeing what the table
refers to other than checking each cell to see if it has a table reference
in it, (like {=TABLE(,B3)}). Hitting Ctrl and ' together will toggle the
formulas on the sheet (' is the key just below the Escape key), that may
help,
Good Luck!
Regards,
Alan.

"Katie" wrote in message
...
No. There is information about the table feature. It is something that
is
part of Excel, but does not work like regular functions.

I did find some sites, but don't understand enough to figure out how the
worksheet was put together originally.

here is a site I found that describes the table feature and function, if
that helps anyone understand what I want to find out.

http://support.microsoft.com/default...b;en-us;282851


Katie



"Alan" wrote:

That sounds like a UDF or User Defined Function, ie something that
someone
has written, not a built in Excel function.
Try hitting Alt and F11 together to open the VB editor and look in
Sheet1,
Sheet2, This Workbook etc on the left.
Look for something that starts 'Function Table () or similar.
Copy and paste the code here and maybe someone will be able to help you
with
it,
Regards,
Alan.
"Katie" wrote in message
...
I have a workbook that uses a function called table(,cell).

I need to undertstand how that feature is used and how the table was
set
up.
Is there a way to reverse engineer the existing workbook? Unlike
other
functions, the predecessors are not neatly indicated in the arguement
list.

Please help!

I have a workbook that uses a function called table(,cell).
.. how that feature is used and how the table was set up.

{=TABLE(,Cell ref)}

Its a "one variable data table" which is used for sensitivity analysis.
Albeit it looks like an array formula, it's not. The table needs to be set up
via the menu command: Data Table ..

You could try typing in Excel's help: one variable data table
for more information

Try also the 2* samples on data table in my archives:
*one variable, 2 variable

One variable data table example.xls
http://savefile.com/files/1007074

2 variable data table example.xls
http://savefile.com/files/46276

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Katie" wrote:
No. There is information about the table feature. It is something that is
part of Excel, but does not work like regular functions.

I did find some sites, but don't understand enough to figure out how the
worksheet was put together originally.

here is a site I found that describes the table feature and function, if
that helps anyone understand what I want to find out.

http://support.microsoft.com/default...b;en-us;282851


Katie



"Alan" wrote:

That sounds like a UDF or User Defined Function, ie something that someone
has written, not a built in Excel function.
Try hitting Alt and F11 together to open the VB editor and look in Sheet1,
Sheet2, This Workbook etc on the left.
Look for something that starts 'Function Table () or similar.
Copy and paste the code here and maybe someone will be able to help you with
it,
Regards,
Alan.
"Katie" wrote in message
...

Is there a way to reverse engineer the existing workbook? Unlike other
functions, the predecessors are not neatly indicated in the arguement
list.

Please help!