从其他受保护的Excel文件中收集数据 [英] collect data from other protected excel files

问题描述

您好，我在Excel 2007中有一个问题。如何从其他受保护的Excel文件中收集数据？可能吗？谢谢。

Hello, I have a question in Excel 2007. How can I collect data from the other protected excel files? Is it possible? Thanks.

推荐答案

你的问题非常广泛，所以让我们分解它并回答"它有可能"吗？取决于它们如何受到保护以及受保护的内容。

Your question is very broad, so let's break it down & answer the 'Is it possible'? Depends on how they are protected and what is protected.

（1）文件是Passworded，因此是加密的。否。

(1) The File is Passworded, hence, encrypted. No.

（2） 工作簿受保护。来自Visible&隐藏的工作表。

(2) The Workbook is Protected. Yes from Visible & Hidden sheets.

（3）工作表受到保护。来自Visible&隐藏的工作表，即使所有复选框都已清除。

(3) The worksheet is protected. Yes from Visible & Hidden sheets, even if all checkboxes are clear.

如何操作？这取决于你的目的。您是否将数据聚合到一个工作簿中？您是选择一个还是多个来查看某些数据点？

How to do it? This depends on your purpose. Are you aggregating the data to house in one workbook? Are you selecting one or more to view certain data points?

（A）您可以使用数组公式在工作表上通过公式链接到工作簿（例如{='C：\ Users \\ \\ MyName \Documents\CheckExcel \ MySampleBook.xlsb'！MyRangeName}）

(A) You can link to workbooks via formula's on a worksheet using array formula's (e.g. {='C:\Users\MyName\Documents\CheckExcel\MySampleBook.xlsb'!MyRangeName})

（B）您可以使用Excel的"外部数据"功能。

(B) You can use the 'External Data' features of Excel.

（C）您可以设置外部数据源并将其链接到数据透视表。

(C) You can setup an external data source and link that to a PivotTable.

（D）您也可以设置vba例程来执行此操作。

(D) You can also setup vba routines to do this as well.

这篇关于从其他受保护的Excel文件中收集数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！