Solved

unable to save an excel document

Posted on 2011-09-26
6
258 Views
Last Modified: 2012-05-12
hi experts,

 I have an excel expense report that i'm trying to save and I get this pop up with the following and i'm not sure what it means or what to do.

the following features cannot be saved in macro-free workbooks:
to save the file with these features, click NO, and then choose a macro-enabled file type in the file type list.
to continue saving as macro-free workbook, click yes.

0
Comment
Question by:frankbustos
  • 3
  • 3
6 Comments
 

Author Comment

by:frankbustos
ID: 36601717
Is it because I've used foreign
currency converter?
0
 
LVL 13

Expert Comment

by:nike_golf
ID: 36601763
The workbook has a macro in it and is asking you if you want to remove the macro and save it as a regular .xlsx file. If you want to retain the macro's save it as an .xslm file.

NG,
0
 
LVL 13

Expert Comment

by:nike_golf
ID: 36601775
Sorry that should read .xlsm (macro enabled workbook)

NG,
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:frankbustos
ID: 36602013
I’ve tried to save it already in .xlsm format and others but it still didn’t let me save or submit.
0
 
LVL 13

Accepted Solution

by:
nike_golf earned 500 total points
ID: 36602063
You might also look at the "Trust Center"  as is discussed in this thread (http://www.pcreview.co.uk/forums/excel-2007warning-following-fetures-cannot-saved-macro-free-workbook-t3037442.html)

NG,
0
 

Author Closing Comment

by:frankbustos
ID: 36907472
great thanks for your help!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

820 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