Tuesday, March 3, 2015

4.Multiple Worksheets in the same workbook and Scheduling Workbooks.


#We can include multiple worksheets in the same workbook.These worksheets may be created on same folder from same business area (or) other busniess area (or) other

folder from other business area (or) same business area.

To create new sheet go to sheet-> new sheet and click on edit sheet for editing.

#Scheduling:Whenever the report is taking much time to execute we can use this option.

Go to File->Scheduling->Select the required worksheets,mention time and date and frequency.

We can manage the scheduling by using scheduling manager.

File->Manage Workbooks->Scheduling Manager.

No comments: