Thank you for replying and for the images.




I don't understand what a "proper" table is. Maybe it's something other than what Excel 2000 provides...? All of the tables in my other Excel files (around 50 or so tables in 4 files) were created the same way, but only the one table in the file I uploaded had any problems, and then it was only after several years.



Unfortunately, the Parameters list on the right of your images do not easily correspond to what I have in my Excel 2000, so it's kinda difficult to compare. But I would like to thank you anyway for the time and trouble you spent working on my problem.


Everything works correctly now. Not sure what the problem was. By copying the file from one drive to another and then back to the original drive, I was able to open my file and have the table come up correctly, so I think I'm okay now. (That process, by the way, took me a few hours of fiddling around to get the file to open and close correctly. Go figger.)

Might be. I can't remember that far back. But in ribbon Excel-world, formatting your data range as a table does a bunch of things that make adding data, filtering, and doing formulas that you can repeat down the column easier.

Ten Reasons to use Tables in Excel | Chris Menard Training gives a pretty good look at what tables can do. The main thing I thought of with what you are doing is that the table will automatically see when you're adding a new row beneath the existing ones, and format them as part of the table. So if a chart were created off that column rather than cells (A2:A5), it would include any new data as you built it up.

I think back then they were called Lists. You can select your table cells or a cell within that table, then Data|List|Create List… (or Ctrl +L)

In the sheet ARM I have set up formulas so that the chart automatically should update, including dates.

Attached Files

ARM.xls (62.0 KB, 6 views)