Monday, June 21, 2010

Information about Microsoft?

I have created some data in Excel with the different files but i want that all my file should be linked to each other which can be easy to refer and easy to use in my absence.



Can anybody tell me is their anything in microsoft to link all the file togeather. e.g the way we do in microsoft Access- I m using office 2003. Need a help



Information about Microsoft?stinger



I hope this comes close to your query. http://support.microsoft.com/kb/211802



Hope this helps ;)



Information about Microsoft?virus scanner



You have to create PivotTable or PivotChart report to consolidate multiple data ranges while using Excel spreadsheets.



When you have several Microsoft Excel lists with similar categories of data and you want to summarize the data from the lists together on one worksheet, one option is to use a PivotTable or PivotChart report.



Setting up the source data : When you consolidate data from multiple lists or worksheets, the lists or worksheets must have matching row and column names for items that you want to summarize together. Do not include any total rows or total columns from the source data when you create the PivotTable or PivotChart report.



Using named ranges when source data is likely to expand To make the PivotTable or PivotChart report easier to refresh when the source ranges change, name each source range and use the names when you create the PivotTable or PivotChart report. If a named range expands to include more data, you can refresh the report to include the new data.

No comments:

Post a Comment