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
Solved

Can't save an Excel 2010 macro file

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

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.
Most MSPs worth their salt are already offering cybersecurity to their customers. But cybersecurity as a service is wide encompassing and can mean many things.  So where are MSPs falling in this spectrum?
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

790 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