Thank you,

the problem was that I shared the workbook,

I never realized that would prevent you from creating a pivot table.

Thank you


"Max" wrote:

when I go to the insert tab the options are all greyed out.

Try clicking Tools Unprotect workbook
(you may need to supply the password)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:58
xdemechanik
---