Thanks, that worked perfectly. I ended up adding in a dynamic named
range for my pivottable, then hid the sheet where the table resides. I
added a macro for the end user to update the pivottable, without them
needing to know that it was even there. For the arrays, I added a
dynamic named range for each of my columns, so that they would update
accordingly when new rows are added.