Reporting → Working with SBM Data in Excel → About Getting SBM Data into Excel
You may want to bring SBM data into a Microsoft Excel spreadsheet so that you can manipulate and distribute the data. There are two methods of getting SBM data into Excel:
Using the Excel Link – This method enables you to quickly export static data into Excel. You can export listing-type, tabular-formatted, and graphical reports. When you export SBM graphical reports to Excel, report data is exported into a spreadsheet. For details, refer to Using the Excel Link.
Using Microsoft Excel's Web Query Feature – This method enables you to manually import "dynamic" data into Excel. If you use a Web query in Excel, data in your spreadsheet is updated each time that you open it. For details, refer to the Knowledgebase at serena.com.
Copyright © 2013–2014 Serena Software, Inc. All rights reserved.