I have a small issue here.
1) I am sending an excel sheet to my users . This sheet has a macro. In this sheet my users will paste varying rows of data values GL Accountwise / Buisness Areawise / Currencywise.

2) Then they will run the macro ( I recorded the macro ) which converts the data to an excel official table ,converts the data into a summarized format by creating a pivot table in the sheet itself through the macro . If the data is not converted to a table the macro does not work.

This is all working fine. But the issue is that if users re-run the macro a second time without converting the table to a range ,the macro gives an error “A table cannot overlap another table”. I need to reset the base data from a excel table to a range from the macro itself .

I tried to record a macro which resets the table to range from the menu, but the macro seems to record nothing.


Could you help?

Thanks.