Cannot open PivotTable source file

Question

I've been running a spreadsheet for several years (created in Office2007) that uses pivottables to prepare sales information for my staff byindividual and month - from a Sheet in the same file. 

The information is created based on Name, Month & Year - and I'm able to successfully retreive infromation from the same Master Sheet for all months up to October then ALL (<--- this is an update) of pivottables started having an issue. 

The sales data should automatically populate the Pivottable but in this case it's blank and "Refresh All" brings a popup titled "Passoword" and  "(about 8 encription characters) is protected."   And asks for a password. 

Entering a password doesn't bring up the data and the chart stays blank.And it asks for the password every time I try to update the chart (run the pivottable)

If I put in an incorrect password - the message "cannot open PivotTable [S:\folder1\folder2\Monthly commission spreadsheet\File Name.xlsx]Master' - which may or may not be helpful in figuring this out.

______________

Environment: 

Win8R2 server

Win10 clients

Office2007 sp3

___________________

I've tried deleting all passwords and security (there was both a password to view and modify)

Saved as a different file

Verified the data on the spreadsheet was correct

It will create the chart for Oct Nov Dec for prior years and for prior months in 2015. 

OH Great Smart People of the Internet - Help!

Answer 1

This issue is closed - it seems I discovered information that closes this but I've opened a new question.

Stay Tuned!