Pivot Table and Emailing

  • Thread starter Thread starter Chelsea S
  • Start date Start date
C

Chelsea S

Hello Everybody,
I have a pivot table that we have sent to out side locations, They are
viewing this table as "read Only" although I haven't protected the worksheet.
Do you guys know of any setting I need to check that could have "secretly"
put this Pivot table as read only?
Thankyou
 
Hi Chelsea,

Right-click the file in the Windows Explorer and choose Properties. On the
General tab see if the Attribute Read Only is checked. This happens when a
file is written to certain media such as CD's under certain conditions.

The pivot table by itself is not Read Only, however, it may be the way you
have published it to to we. When you say you sent it to an outside
location, what exactly do you mean? Are you publishing it as a web page,
saving the file to a server which others can access, or are you attaching
the Excel file to an email and sending it?

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table report invalid 0
How to base a pivot table on another pivot table? 3
Excel 2010 Slicer Connection / Pivot Table Problem 3
Excel VBA For excel 0
pivot tables in multiple workbooks using one datasheet? 3
pivot table loosing decimals (vba) 1
pivot table calculated field 1
Compare 2 Pivot Tables 2

Back
Top