Option 1:
I have 2* sample files 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

Take it away & try checking the differences between example (2) above & what
you've set up over there.

Option 2:
If you're still unable to get it going despite the above,
upload your sample file using a free filehost, then post a link to it here

Eg, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here in your reply

I'm using xl03, so pl save/upload only as this version (if you're using xl07)
I'm not able to open/read xlsx files.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Damon G." wrote:
I have tried all of those remedies and nothing seems to work.

1. I have the Tools-Options set to AUTOMATIC Calc. I have even executed the
F9 key multiple times.

2. I have tried to swap the order of the rows/columns and even the
references. Still no luck.

3. I have the base formula in the cell that it references for the amount. It
is a simple "=" the cell with the value and it still just repeats. I am so
confused because it's not making any sense to me.

If you have any other tricks up your sleeve, I am all ears. Thank you so
much for the earlier advice. This is very baffling.