Greetings all
I have a procedure that creates a pivot table. When new data is added the procedure deletes the old table and creates a new one that includes the new data. The sheet number is incremented up each time IE.
Sheet(148) Any way to turn back the clock on this? I have tried renaming the sheet in the properties window but the next time the procedure runs it's back up to what it was plus one.
I have a procedure that creates a pivot table. When new data is added the procedure deletes the old table and creates a new one that includes the new data. The sheet number is incremented up each time IE.
Sheet(148) Any way to turn back the clock on this? I have tried renaming the sheet in the properties window but the next time the procedure runs it's back up to what it was plus one.