Skip to Content

"Convert to Formula" infos get lost

Nov 09, 2017 at 12:40 PM


avatar image
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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Nov 09, 2017 at 12:54 PM

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

10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 09, 2017 at 01:33 PM

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,...

10 |10000 characters needed characters left characters exceeded