HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 61
Deleting Data Sheets, Deleting the Query Log, Saving and Exiting the Excel Client
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 61 highlights
Deleting Data Sheets Data sheets remain until you manually delete them. Manually deleting a data sheet causes any embedded charts associated with that data sheet to disappear as well. To delete a data sheet: 1. At the bottom of the Microsoft Excel window, click a data sheet tab to enable the sheet to be deleted. 2. Point to the name of the data sheet tab and then right-click. 3. On the shortcut menu that appears, click Delete. 4. In the confirmation dialog that appears, click OK. The data sheet is deleted. Any embedded charts associated with that data sheet disappear as well. Deleting the Query Log You can also delete the query log, which is by default a hidden sheet, by making it visible and then using the method described above to delete it. To delete the query log: 1. Make the Query Log tab visible by following the instructions in "Accessing the Excel Client Query Log" (page 60). 2. At the bottom of the Microsoft Excel window, point to the Query Log tab and then right-click. 3. On the shortcut menu that appears, click Delete. 4. In the confirmation dialog that appears, click OK. The query log is deleted. The next time that you initiate a new query using the Excel workbook, a new hidden query log sheet is created. Saving and Exiting the Excel Client To exit the HP 3PAR System Reporter Excel client workbook, on the File menu, click Close. Upon exiting, Microsoft Excel will prompt you to save changes. If you have added customized charts and/or data sheets, as described in "Working with Excel Charts" (page 98), you may want to save your changes when prompted. However, it is not necessary to save changes and in most cases it is not desirable to do so. Saving the Excel workbook does not save the Web server information and saved workbooks do not automatically update embedded charts or data sheets when they are reopened. When opening a previously saved Excel worksheet, you may receive a security alert indicating that macros and data connection have been disabled (Figure 22 (page 62)). Deleting Excel Sheets 61