AFO lost of connection

[sven_oehme]

Hi exeperts,

we have a problems with several AFO-workbooks. They have multiple connections to Bex-Queries and saved as xlsx-Format. They lost their connection to the sources of unknown reason. The crosstables in the workbook behave like normal Excel tables. It is still possible to authentificate on BO Frontend and BW4 Backend. But on due reason the displaey crosstables are not refreshing. The workbooks and the datasources can be restored, but this process is not practicable. Because the are many Excel functions and commentaries on the workbook that have been to restore manually aften erasing the former Exel-tables.

I found some old posts about this, but they didn't reference AFO 2.7. We use AFO 2.7.900.92200 and sometimes also 2.8 together with Office 2010 & 2016.

 

Do any of you know a way to link the existing crosstabs as they are with the traditional data sources again?

Greets

Sven