You cannot unless I am mistaken copy and paste a table and be able to work with the data.
You can export the data from your entire document to excel by using the Export button on the Cube, but you would then loose all your formatting.
I think I remember reading that the next release of Bo will allow you this functionality.
In the meantime, if you are heavily relying on Excel, you can use BusinessQuery. It works like BO (you get a query panelā¦) but the output comes in Excel, so you can use the results to do some calculations.
I copy and paste to Excel all of the time. It loses some of the formatting as far as colors go on alerters. But if youāre just looking to be able to copy the data into Excel and work with the numbers from thereā¦no problem. Take a look at what Andreas suggested for different methods of doing this.
Any āformulasā that you have in Business Objects will come over as a value. But you can add formulas, sort, filter and do anything else you normally would do with a spreadsheet.
You can export your report to Excel. In BusinessObjects Reporter go to Data -> View Data and then click on āExportā. Save the file as a ā.csvā file.
You can save as .txt and then open it in Excel, you loose all formatting but you keep all the values from formulas. I use this to create data files for other reports.
Yes this topic was dicussed in great detail and you should find it in FAQ or earlier posts.
In a nutshell, you have to save your report as an HTML file. That creates a subdirectory, go in that subdirectory and find your report.
Donāt Open as HTML, Right click and say Open with Excel. You will loose formulae but most of formatting should be preserved.
However, I will say that if you would need to save them frequently then BO has another piece for that. Check their website (www.businessobjects.com) for details.