Solved

Can't save an Excel 2010 macro file

Posted on 2014-10-27
4
348 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
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 19

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

One of the biggest threats in the cyber realm pertains to advanced persistent threats (APTs). This paper is a compare and contrast of Russian and Chinese APT's.
As a business owner, there are many things that keep you up at night. Profit margins, employee retention, human resource protocols, whether your product or service will remain competitive. When you own or manage a technology company that operates la…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
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…

810 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