MATLAB R2019b Opening Excel file, error "This workbook contains links to ... unsafe ..." (want to open readonly).

1 次查看（过去 30 天）
Bruce Ferguson
Bruce Ferguson 2022-1-31
评论： Bruce Ferguson 2022-10-26
SRC_file = xlApp.Workbooks.Open(SRC_dir_name) % also tried (SRC_dir_name,readOnly) or ...'readOnly') unsuccessfully.
Full error message: "This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have."
  1 个评论
Bruce Ferguson
Bruce Ferguson 2022-10-26
Using a MATLAB script I want to open and readonly many Excel files. When each is opened, I get the "external links" error message above, at which I must select the "keep working with the data you have" option manually. I want to suppress this message. The file is not open before. One solution might be able to edit all the Excel files using Excel ahead of time to turn this off (write a macro?) but would rather do something in MATLAB like: "Excel.Application.Workbooks.Open(filename, 'readonly')", but that doesn't work.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Animesh Gupta
Animesh Gupta 2022-2-3
Hello Bruce,
It is my understanding that you are unable to load an excel file in your workbook due to the error message. I found that this error is related to the file being used.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by