Solved

Can't save an Excel 2010 macro file

Posted on 2014-10-27
4
375 Views
Last Modified: 2014-10-29
I have a user that is unable to save a macro file in Excel  MS Office 2010, on Windows 7 machine.  I have tried to stop the antivirus (Kapersky Endpoint Security 10) even with admin rights but it doesn't let me to stop it. I have reset the macro security settings also, but still unable to save the file. I made a copy of the file, performed the repair process but when it finished process only the formulas were there but no data. Please let me know which other options I may use to save this file. Thanks.
0
Comment
Question by:Hunter24
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 19

Assisted Solution

by:regmigrant
regmigrant earned 50 total points
ID: 40408242
Need a little more information

What error message do you get?
what file format are you saving in?
What does the macro do - ie: entirely within excel or calls out to DLL/Add-ins/filesystem?
0
 
LVL 20

Accepted Solution

by:
marsilies earned 450 total points
ID: 40409450
You have to make sure you're saving as a macro-enabled workbook. It's one of the file options in the save as window. See here for more info/instructions:
http://www.dummies.com/how-to/content/saving-and-using-an-excel-2010-macroenabled-workbo.html
0
 

Author Closing Comment

by:Hunter24
ID: 40410663
Thank you very much guys! I was able to save the file following Marsiles weblink. Thanks again.
0

Featured Post

Prevent Ransomware with Total Security Suite

With recent ransomware attacks topping the headlines, it might seem like there'e no hope in the battle against these advanced threats. Learn more about how WatchGuard's Total Security Suite can effectively prevent ransomware attacks including Petya 2.0 and WannaCry!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

696 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