Hi all,
I have a report that has pivot tables which update from Microsoft Dynamix (a database program)... Layout as follows:
Sheet 1: No pivottables, only charts
Sheet 2: 2 pivottables (that pull info from hidden sheets 5 & 6)
Sheet 3: 2 pivottables (that pull info from hidden sheets 5 & 6)
Sheet 4: 1 pivottable (that pulls data from Microsoft Dynamix)
I tried doing an auto_open macro to refresh all of the data, but it doesn't seem to work as i also need the report to remain protected once updated... I used this:
Can anyone help with creating a macro that will unprotect all sheets, then refresh all pivottables and data, then reprotect all sheets?
Bookmarks