All our users run queries from web browser but occassionally download the results to excel and email them to other users. In cases where the results have hierarchies, indent symbol is downloaded to excel too and when the file is re-opened in excel, prompt to login to BW server pops up. We found out that this pop up is purely to get the symbol. Users cannot get around this popup unless they login. Not all users have login to BW yet and hence a major issue.
I did find an option in Excel in "Save as" functionality where a checkbox can be unchecked that says "Download images from web if not stored in Excel". When the file is saved with this option, popup to login to BW no longer shows up.
Is this the only option? Any settings in BW to not download this symbol when saving to Excel?
BTW: CSV format works great, but its tough to convince the users to use this all the time.