Hi, Has anyone experienced a similar problem and can perhaps help? I created an Excel template and successfully have it outputting 2 separate fex's to 2 different worksheets but the VB code that I added which refreshes the pivot tables (located on other worksheets) is now gone! It appears as though the VB code is actually working because the pivot tables are refreshed but I do not see any of the VB code in "ThisWorkbook" in Excel.

Can anyone help? Thanks!

Hi developing,

Suggestion from internals: you should open a case with Information Builders' Customer Support Services for assistance. We’ll need your original XLS file along with the saved .mht file.

To open a case, please either call at 1-800-736-6130, or access the online system InfoResponse. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps.

Cheers,

Kerry