?
Solved

Can't save an Excel 2010 macro file

Posted on 2014-10-27
4
Medium Priority
?
393 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 200 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 1800 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

The recent Petya-like ransomware attack served a big blow to hundreds of banks, corporations and government offices The Acronis blog takes a closer look at this damaging worm to see what’s behind it – and offers up tips on how you can safeguard your…
The well known Cerber ransomware continues to spread this summer through spear phishing email campaigns targeting enterprises. Learn how it easily bypasses traditional defenses - and what you can do to protect your data.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

770 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