SAP Knowledge Base Article - Public

2505916 - Excel Refresh Query not Working as Expected


You created an Advanced Filter query in a workcenter view however when you refreshed the data in Excel Add-in you have different data from that filter.

Reproducing the Issue

Example using Accounts View in SAP Hybris Cloud for Customer

  1. Go to Customers Workcenter
  2. Go to  Accounts View
  3. Select filter All Accounts
  4. Go to Advanced Filter and filter the data as you like
  5. Click in Export
  6. Open in Excel
  7. Modify the data (for example delete rows)
  8. Click in Refresh
  9. Excel has more data than your initial download



Excel Add-in respects the data from the query as for example All Accounts, once you hit Refresh it will ignore the Advanced Filter and will download the All Accounts query again.


This is the expected system behavior.


KBA , SRD-CC-FED , Feeds , How To


SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions