The Excel macro is not honoring row and column limits

Adaptive Staff

The Excel macro has settings to limit how many rows and columns are rendered in the finished display.  If a spreadsheet is rendered that has anything in a column or row it is rendered regardless of the limitations.  Example:

A sheet is uploaded that has visible data in 15 columns and 60 rows with formulas to display data in the remaining rows up to row 500.  The macro is configured to display 10 columns and 60 rows.

Once the page is saved all 15 columns and 500 rows are displayed; why?

Rick Mortensen

Update to the original question; the problem appears to only be an issue when attempting to change the settings for an already established Excel macro.  For instance:

1. Upload a spreadsheet

2. Insert a macro displaying 50 rows and 12 columns

3. Update macro to display 60 rows and 12 columns

Notice that the number of displayed rows doesn't change.  I tried this with Chrome, Firefox, and IE; no difference.  I also see that it doesn't matter if the macro is deleted, the page saved without the macro, and a new macro inserted with the new settings.  Once a macro is established on a given page it cannot be changed to display a different number of rows or columns (increasing or decreasing the number doesn't matter).