Home >Topics >excel >How to open excel that does not enable macros but contains macro-enabled content

How to open excel that does not enable macros but contains macro-enabled content

coldplay.xixi
coldplay.xixiOriginal
2021-02-09 10:45:03184835browse

How to open excel without macros enabled but containing macro-enabled content: First create a new EXCEL document and click [File]; then click [Options], and click [Trust Center Settings]; finally click [Macro Settings] ], check [Enable all macros], and click Save.

How to open excel that does not enable macros but contains macro-enabled content

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to open excel that does not enable macros but contains macro-enabled content:

1. First, on the computer, click EXCEL to start and create a new EXCEL document.

How to open excel that does not enable macros but contains macro-enabled content

#2. After opening the EXCEL table, click [File] on the upper left.

How to open excel that does not enable macros but contains macro-enabled content

3. Click [Options] on the [File] page, as shown in the figure below.

How to open excel that does not enable macros but contains macro-enabled content

4. Then in the page that opens, click [Trust Center Settings], as shown in the figure below.

How to open excel that does not enable macros but contains macro-enabled content

5. Then in the page that opens, click [Macro Settings], check [Enable all macros], and click Save.

How to open excel that does not enable macros but contains macro-enabled content

Related learning recommendations: excel tutorial

The above is the detailed content of How to open excel that does not enable macros but contains macro-enabled content. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn