Strange error

I have one sheet which acts like a database, and another where I have a PivotTable made from that database. Some VBA is there to refresh the table and what-not.

When I exit Excel I get

'no item of that name exists in pivot table report. rename 'my label' to '1'

error. I don't access it via VBA, and I cannot figure out why this happens. Any ideas?

Found the reason!

In my before close event, when I reset some variables to zeros, even though i activate the correspoding sheet, Excel updates the sheet with pivot table too. I don't see why though, but when I remove this line everything works just fine.

Cheers.

Will use this thread for another matter.

I can't figure out why pivot table formats some rows in a different way, as shown in the picture. All the data has been entered the same way, through the same user form.

Ideas?

that is strange but the pivot table sheet retains formating so if somehow the cells had been left aligned at some point in the pivot table, that would be retained, even if it was refreshed. Also the macro code made do something strange!

regards

Dav

But the same thing ocurrs when I turn Preserve formatting off! Further more, I've tried to delete the whole sheet with the Pivot report, and create a new one (with the same name, though), and nothing changes.

Could it be that Excel remembers Pivot table's name for formatting (and other) purposes?

Cheers,
Ivan.

Reason behind this proved to be fairly simple.

Pivot table aligned numbers to the right, no matter if I 'manually' aligned cell ot the whole column to the center. And that's basically it. It does NOT allow me any other alingment, but right. I could change the format type from number to text though, and it would fix the problem.