Solved

unable to save excel 2016 documents

Posted on 2016-08-15
16
63 Views
Last Modified: 2016-08-24
On windows 10 with office 2016 we are unable to save new workbooks. When you create a new workbook then go to file - save as - then click browse nothing happens. No browse window opens to select a spot to save the file. If you create a new file from a template you are able to save it. You can also modify an existing file and save it. Just not new workbooks.
0
Comment
Question by:Njacobe
  • 7
  • 6
  • 2
16 Comments
 
LVL 90

Expert Comment

by:John Hurst
ID: 41757022
I have Office 2016 on Windows 10 and have had for months. It all works.

1. Uninstall Office 2016, restart, install Office 2016 and test.

If no:

2. Create a new, test Windows User Profile (account). Log into the new Windows Account and test Excel in the new account.
0
 

Author Comment

by:Njacobe
ID: 41757318
Tried that still no luck. Every other app works just not excel.
0
 
LVL 17

Expert Comment

by:xtermie
ID: 41757681
Hi, some add ins may cause problems.  Do you have IBM trusteer rapport installed?
It has been known to prevent files from being saved when using Office 2013 apps and may do the same with 2016.

Try opening Excel in Safe Mode (by holding down the CTRL key while starting it until asked to confirm that you want to start in Safe Mode) can you then create and save a document.

If so, it is likely that you have an Add-in that is causing the problem and one that does prevent the saving of documents is a "Send to Bluetooth" Add-in.

See the part about "Disable the Startup folder add-ins" and Disabling COM add-ins" in the following KB article:

https://support.microsoft.com/en-us/kb/921541?p=1

Hope this helps
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41757682
Assuming other computers work, and that it is not a network / server issue, then you need to do a Windows 10 Repair.

Go to the Media Creation Link

https://www.microsoft.com/en-us/software-download/windows10

Click on Upgrade to Windows 10 (even if Windows 10 is running), click on the Download button, select Open (Run) but NOT Save. Allow the program to run. Allow drivers to update. Then select Keep Everything.

You can also Keep Data, or Keep Nothing. Keep Nothing is very close to a clean install.
0
 

Author Comment

by:Njacobe
ID: 41760901
I uninstalled and reinstalled office no luck. Checked and didn't see any GPO that would block it. Seems like it's random computers across the network.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41760905
There must be a server or network issue because of the randomness and the fact that Excel can generally save just fine.
0
 
LVL 17

Expert Comment

by:xtermie
ID: 41760995
Try opening Excel in Safe Mode (by holding down the CTRL key while starting it until asked to confirm that you want to start in Safe Mode) can you then create and save a document.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:Njacobe
ID: 41761020
Tried safe mode still have the same issue.
0
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
ID: 41761083
I would suggest re-installing Windows, but you say "random and multiple computers"  

You might try Wireshark and do some packet sniffing on troubled computers.
0
 

Author Comment

by:Njacobe
ID: 41764480
Tried wireshark and didn't see anything unusual. Is there a permissions issue or something else?
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41764488
Make sure the server user folder is permitted to the user trying to save.
0
 

Author Comment

by:Njacobe
ID: 41764734
Even with the computer off the domain they can't save. It's strange they you can save a new template and an existing file but not a new workbook.

No error messages or anything. When you click save as nothing happens no dialogue box our anything.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41765122
Take one machine, do a fresh install of Windows, update it, install Office and test. Now add your remaining applications and test at each step. What happens?
0
 

Author Comment

by:Njacobe
ID: 41769424
seems like reimaging is the only solution.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41769430
I pointed to a reinstall (== Windows 10 Repair install) in https:#a41757682   and that is what you did.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

With Windows evolving further, the built-in protective mechanisms get better and better. Still, Microsoft is not very good at introducing those to the technical community. This article is about a new bitlocker functionality that could revolutionize …
If you use NetMotion Mobility on your PC and plan to upgrade to Windows 10, it may not work unless you take these steps.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now