将一个Google文档电子表格链接到另一个最多允许50个参考?我有五百多 [英] Linking one google docs spreadsheet to another maximum 50 reference allowed ?? I have More Than 500 Hundred

问题描述

我从此答案中使用了以下方法:

I used the following approach from this answer:

首先转到您要从中导入数据的电子表格 (docA)并观察URL中提到的密钥的值(例如: https://docs.google.com/spreadsheet/ccc?key=在这种情况下，ABC#gid = 0 密钥是ABC).

First go to the spreadsheet that you want to import the data from (docA) and observe the value of the key mentioned in the URL (Eg: https://docs.google.com/spreadsheet/ccc?key=ABC#gid=0, in this case the key is ABC).

现在转到docB中的单元格，然后使用importRange函数 导入数据.

Now go to the cell in docB and use the importRange function to import the data.

=importRange(, !:)

Eg: =importRange("ABC", "Sheet1!A1:B10")

如果您只想导入一个单元格:例如=importRange("ABC", "Sheet1!A1");

If you want to import just one cell: E.g. =importRange("ABC", "Sheet1!A1");

如果您不提及工作表的名称，则使用第一张工作表.

If you don't mention the name of the sheet, the first sheet is used.

这非常有帮助 我使用了此功能，Google提示了一个通知

it was very helpful i used this featured and Google prompted a notification that

出现问题 目前，单个表格中的Google表格中的电子表格最多仅支持50个ImportRange函数.

There was a problem At this time, spreadsheets in Google Sheets only support up to 50 ImportRange functions in a single spreadsheet.

任何解决方案???

推荐答案

您似乎仍在使用旧表:

单个电子表格最多支持50个IMPORTRANGE调用.新版本的Google表格中已删除了此限制.

A maximum of 50 IMPORTRANGE calls are supported on a single spreadsheet. This limit is removed in the new version of Google Sheets.

参考

切换到新工作表.

这篇关于将一个Google文档电子表格链接到另一个最多允许50个参考?我有五百多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！