锁定 - 从多个Excel文件收集的数据，在Access中复合，并在另一个Excel文件中显示 [英] Lockup - Data collected from multiple Excel files, compounded in Access, and presented in another Excel file
问题描述
我一直在寻找高低，但没有找到我的问题的答案。所以这里是：
I have been searching high and low, but not really found the answer for my question. So here goes:
我有一个（15-35）Excel文件（后端）用于数据收集。它们被分发到每天输入数据的不同部门 - 文件通常保持打开状态。
I have a number (15-35) of Excel files (backend) which I use for data collection. They are distributed to different departments who enter their data daily - the files are often left open.
然后我通过链接表从Access数据库中的这些excel文件中导入数据。
I then import the data from these excel files in an Access database by linking the tables.
然后我使用联合查询将所有链接表组合成一个表。
I then use a union query to combine all the linked tables into one single table.
此表我然后链接（导出） ）在另一个Excel文件（前端）中，然后我可以在其中对收集的数据进行直观呈现。
This table I then link (export) in another Excel file (frontend) where I can then make a visual presentation of the data collected.
现在我的问题是，如果其中一个后端excel文件打开，我的演示文稿excel当我尝试导入最新数据时，文件将失败。
Now my problem is that if one of the backend excel files are open, my presentation excel file will fail when I try to import the newest data.
我曾经通过使所有后端excel文件"共享"来解决此问题。但这不是一个可行的解决方案，因为它使得后端excel文件运行速度非常慢，并且在宏和锁定单元方面给出了相当多的麻烦。
I used to get around this problem by making all the backend excel files "shared". But this is not a viable solution as it makes the backend excel files operate very slowly, and give quite a few headaches in regards to macros and locked cells.
我有什么方法可以收集即使后端excel文件已打开，我前端的数据仍然很好？
Is there some way I can collect the data in my frontend excel even though the backend excel files are open?
希望你能提供帮助。
推荐答案
我曾经通过使所有后端excel文件"共享"来解决这个问题。但这不是一个可行的解决方案，因为它使得后端excel文件运行速度非常慢，并且在宏和锁定单元方面给出了相当多的麻烦。
I used to get around this problem by making all the backend excel files "shared". But this is not a viable solution as it makes the backend excel files operate very slowly, and give quite a few headaches in regards to macros and locked cells.
我有什么方法可以收集即使后端excel文件打开，我前端的数据仍然很好？
Is there some way I can collect the data in my frontend excel even though the backend excel files are open?
Hi MadsBro，
Hi MadsBro,
您可以在Access中导入数据，而不是链接到Excel文件，然后继续在那里工作。
Instead of linking to the Excel files, you could import the data in Access, and continue to work from there.
Imb。
这篇关于锁定 - 从多个Excel文件收集的数据，在Access中复合，并在另一个Excel文件中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
