Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex Workbook Migration issue

Hi Gurus,

I have the requirement to migrate the 3.5 Workbooks into 7.3 system. And I am getting the same issue while migrating the two workbooks.

I have searched in SCN but not able to find the suitable answer.

Steps I have performed:-

1. Open the Workbook in 3.5 and saved as with new name.

2. Open the new Workbook in 7.3 and remove the 3.5 queries and attach the migrated queries and save it.

3. Opening the new migrated query throwing the error as in attached snapshot.

The issue I checked in VBA code as below:-

Sheets(sh_01).Select                             

ActiveSheet.PivotTables(pv_01).PivotCache.Refresh

(When I am removing the Select with Activate its working but I am not sure if sheet is inactive)

Can you also please let me know if any mandatory prerequisites need to do before migration and after if any setting after migration.

Thanks in advance.

Regards,

Harsh

issue.png (9689 B)
Former Member
Not what you were looking for? View more on this topic or Ask a question