"Convert to Formula" infos get lost

[Former Member]

Dear experts,

I have a workbook with SAPGetData formulas in it. This way, I can use the Query (full crosstable), but at the same time, pick some special fields, without having to reference them in Excel hardcoded (more flexible, if query changes or user navigates).

The workbook works fine and fulfills all needs of the user.

BUT. Sometimes he needs to save the file locally, add some information or send it to a recipient outside the company.

When he saves the workbook as regular XLS-File (or XLSM-File), enters some new data to the file and sends it via E-mail. The data disappears (sometimes). There is no error or any sign like 'N/A' in the fields. The cells are simply empty. This concerns only the SAPGetData-fields - the data in the crosstable however stays in place.

We work with Microsoft Office Project Profesional Plus 2013 and Analysis for Office 2.3

Is this just a bug (e.g. of Analysis or Excel)? Because sometimes (especially within the company) it works fine!

I'm gratefull for any advice.

Thank you!

[Former Member]

Hello Tammy,

thanks for your answer! We wanted to update to AfO 2.5, but it doesn't work with our current release of BIP (4.1 SP3). We can discuss updating to 2.4 - do you think that would improve the issue?

We discoverd, that the data disapears sometimes (within the company - even same computer), if data should be displayed, which was hidden before (e.g. in closed grouping) or if columns or rows are entered on the same sheet as SAPGetData-formulas..

We don't have any problems sending the files around, as long as they don't contain any SAPGetData formulas. But I'm already a little bit relieved, if you tell me that it should work and can probably be fixed,...

[TammyPowlas]

Hi Nina - 2.3 is a really old version; is there a chance you could update to Analysis Office 2.5 SP2 (or the latest) and try this again? I do the same as you, send files around the company and no issues so far