Pivot tables, linking to a named range as a source to a pivot table

[Karen]

I have created a main worksheet within the same workbook
of many pivot tables, and I want to use this same
worksheet as the source of information to these different
pivot table sheets off of which I create charts.

I want to use a named range because there are over 4,000
rows in this main worksheet.

I am not sure if I need a "=" to start the reference or
what to do.

I thought I should just use nameofworksheet!database if I
name the range "database", but when I point and click to
the sheet, it is just inserting the name "database"
without the name of the worksheet in front of it.

In other words, I need the proper syntax, because I am not
performing a function to this named range.

Thank you.

 

[Debra Dalgleish]

There are instructions here for creating a dynamic named range, and
using that as the source for a pivot table:

http://www.contextures.com/xlPivot01.html#Dynamic