Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Excel pinned files disappeared

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

Excel pinned files disappeared

Postby chicagotech » Tue Jan 23, 2018 10:34 am

Situation: the client uses excel 2016. He reports Excel pinned files disappeared.

Troubleshooting: 1. Find the largest files (>1MB) in the AutomaticDestinations folder and delete them. Here is how:
1) Open Windows Explorer.
2) Type or copy and paste the following into the address bar:
%AppData%\Microsoft\Windows\Recent\AutomaticDestinations

3) Identify files that are comparatively larger in size than the rest of the file, such as files that have file size of 1 MB or more.
4) Delete the bit file.

2. Run Office repair:

1) Uninstalled Office 2013 (should have done this when I upgraded to 2016 but forgot!)

2) Control Panel|Programs and Features - Right click Microsoft office 2016, select change and then quick repair.


All now fixed and the MRU is now working as it should
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 7178
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Re: Excel pinned files disappeared

Postby chicagotech » Tue Jan 23, 2018 10:34 am

I used the option 1.%AppData%\Microsoft\Windows\Recent\AutomaticDestinations

and only deleted one file which was 1.5 mb.

This worked fine and I was able to re-create the pinned shortcuts.

I will periodically taken a snapshot of my pinned lists in case this happens again.

Good advise. Obviously the half dozen or so files that this link finds relates to each pinned list from the other icons I have in my taskbar.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 7178
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA

Re: Excel pinned files disappeared

Postby chicagotech » Tue Jan 23, 2018 10:38 am

Deleting the 1MB files wasn't enough to fix it. Once I deleted all files larger then 100KB, it fixed the problem.
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
chicagotech
Site Admin
 
Posts: 7178
Joined: Mon Nov 27, 2006 1:24 pm
Location: Chicago USA


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 4 guests