"Your organization requires you to save in a work location to continue" message displayed when savin

mgreenst · #1 08-08-2016, 12:27 PM

I am attempting to insert a pivot table into a new sheet. After selecting the table/range for the data source and clicking OK a message appears stating, "Your organization, 'I', requires you to save a copy of this workbook in a work location to continue." I have tried saving the file to multiple locations on my computer and in the cloud, but the error message persists. The computer I am working on is a personal computer with no corporate firewalls/security setup. I also tried copy/pasting all the info into a new workbook and the same message appeared.

Does anyone know how this issue can be resolved and/or why Excel would be prompting me to save the file to a "work location?" (reference screenshot)

james_ · #2 08-09-2016, 10:58 PM

I am having the same issue and its odd. Tried to create a pivot table to dig through some data and got the same error. I have received this type of file before and did not have an issue creating a pivot table. Hope there is a resolution out there.

candybg · #3 08-10-2016, 09:21 AM

Are you able to just INSERT a new sheet into that workbook?
If so, can you then SAVE AS with a new name?
If not, what message do you get?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to use a "Save As" button without causing digital signatures to become "Invalid"?	jferg	Word VBA	0	02-16-2016 03:04 PM
Saved Word files do not show up in documents list, although "open file location" says they're there	Earwicker	Word	0	10-20-2015 07:40 AM
Disable "Save" & "Save As" & "Print" ribbon	Villalobos	Word VBA	3	07-14-2014 11:37 PM
"Save As" default location	wespa	Word	0	01-30-2014 03:46 PM
Location of file when you hit "save"	daivap	Word	4	09-08-2013 09:51 AM