Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2015, 07:33 AM
gamouning gamouning is offline Need to restore custom functions from a corrupt ".xlam" file ... Windows 7 64bit Need to restore custom functions from a corrupt ".xlam" file ... Office 2013
Novice
Need to restore custom functions from a corrupt ".xlam" file ...
 
Join Date: Nov 2015
Posts: 2
gamouning is on a distinguished road
Default Need to restore custom functions from a corrupt ".xlam" file ...

Hi,

Apologies if this thread already exists somewhere on this forum. I'm new and still trying to find my way around things.



In the meantime, I have an emergency request. I was using Microsoft Excel 2013 and working on a custom function when my system crashed. Initially, I had problems loading Excel after rebooting.

Having disabled my custom.xlam file so that it doesn't load when I started Microsoft Excel, is there any way to salvage my other custom functions that were saved in this file? Is there anyway to access or work on the custom.xlam file outside of Excel?

Thanks in advance for any assistance you can provide.

-Greg
Reply With Quote
  #2  
Old 11-12-2015, 11:03 AM
gamouning gamouning is offline Need to restore custom functions from a corrupt ".xlam" file ... Windows 7 64bit Need to restore custom functions from a corrupt ".xlam" file ... Office 2013
Novice
Need to restore custom functions from a corrupt ".xlam" file ...
 
Join Date: Nov 2015
Posts: 2
gamouning is on a distinguished road
Default

As it turns out, I got lucky and stumbled onto the following fix:

Open Excel
Create Blank Worksheet
Double-clicked onto the corrupt xlam file
Disable Macros when prompted
Toggle to Visual Basic Module (Alt-F11)
Copy/Paste wanted functions
Reply With Quote
Reply

Tags
custom, functions, recover

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
"File" and "Edit" not in menu bar st3inb3rg3r Word 0 12-27-2014 09:13 PM
Change "File As" and "Display As" format davesp Outlook 0 10-14-2014 12:10 PM
Need to restore custom functions from a corrupt ".xlam" file ... How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
How 2 retain MSOffice "Upgraded" on full restore misterbobthetomato Office 0 02-04-2007 11:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft