Web Intelligence export to Excel misses some fields
Our system is running BusinessObjects Enterprise XI 3.1 with SP3 (no fix packs). The behavior I'm seeing is when exporting a particular Webi doc to Excel.
Here is some background info for the document I am attempting to export to Excel. The doc contains a section and the section has a crosstab including description header cells. I have added an additional cell at the top of the section with section specific information in it- nothing that strange yet. If my InfoView (Web Intelligence) preferences is set so that 'Select a priority for saving to MS Excel' is set to 'Prioritize easy data processing in Excel' then the exported document is missing the additional cell at the top of the section (all other data is fine). If the setting is set to 'Prioritize the formatting of the documents' then the Excel export works perfectly.
My question is why would this be? The cell is just a simple dimension (string). My only fear about changing this Excel setting is that there is a warning in the 'Business Objects XI 3.1 Release Notes' guide. It states
Large Web Intelligence documents should be saved to Excel format using the "Prioritize data processing" option". The generated Excel might not open if the document is large and saved with the "prioritize formatting" option.