Problems encountered during workbook Transmission

Today, the group's internal cash flow statement encountered a transmission problem and excel2007 problems.

Find the object type in the transmission connection in AWB, select the workbook, and then select only necessary objects in the group. Select Automatic Collection in set mode.

After entering the workbook technical name of the group's internal cash flow statement, we found a strange problem. There are other queries in a workbook! These are not inserted. So we did the following test, and then inserted and deleted those queries that were not inserted but displayed. The results still exist. We suspect that the query was deleted without using the method of loading the macro in sapbex, but directly deleting the sheet page. I did another test, save a previously prepared workbook as a new workbook, delete the query in it, save it, and then send a request to find that the deleted query still exists! It seems that only a blank template is used as the workbook.

Another problem is the version of excel2007 and business explorer. If you use excel2007 to create a new workbook and save it as in the BW system, the report is opened with excel2003 and the recognized format is displayed, version issues are also a problem in SAP implementation. However, I think excel2007 is better than 2003, but I still don't want to change it.