Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 123
  • Last Modified:

SharePoint 2010 removing required document properties from structure protected Excel 2010 workbook

I have an Excel workbook created in Excel 2010. When I upload documents to SharePoint for my company it automatically populates document properties for the organization.
I have a workbook that I have password protected from opening and also added Structure protection to. When I added the structure protection and closed out it deleted the default document properties that SharePoint requires and therefore leaves the workbook checked out to me until I re-add the properties and check it back in.

What is causing it to remove the properties and how do I rectify this so it stops happening?
0
Susan Strandberg
Asked:
Susan Strandberg
  • 4
  • 3
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
Do you have "Remove personal information from file properties on save" checked? If so, then clear it.
Excel default - Remove personal information from file properties on save> "What is causing it to remove the properties and how do I rectify this so it stops happening?"
Maybe what you are being given is a copy made by putting sheets in a new workbook and that is why property settings aren't transferring ... hard to guess.
1
 
Susan StrandbergAuthor Commented:
@crystal I did check that option and it is NOT turned on. That was the only thing I could think of that would cause that to happen but that is not the case. Thank you for the suggestion.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome

this is something that seems to be saved with the file .. check again when that file is open
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Susan StrandbergAuthor Commented:
I did check on the file itself, not just Excel. That is the first thing I checked when things started to go wrong and that feature is not checked on that Excel workbook.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
the only reason I ask is because (just today!) I discovered that option was set after opening a workbook I created several months ago.  I have turned it off since then.  Today, it was back on!
0
 
Susan StrandbergAuthor Commented:
There was no solution found to this question.
0
 
Susan StrandbergAuthor Commented:
No one was able to give me an answer and the system said the question was abandoned.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now