链接 2 个不同 Excel 文件中的单元格，但如果仅通过电子邮件发送一个文件，则保留数字？
我想知道是否有人可以帮忙？
我有大量 Excel 文件。这些是佣金报表，有些是从美元转换为英镑，从英镑转换为欧元等。
它们是季度报表，目前我必须逐一浏览每个文件并输入该月的具体货币兑换率。
我想如果我能将所有这些报表链接到一个包含转换率的 Excel 文件，那就太好了。然后我可以更新这个单一货币转换文件，所有其他文件都会更新。
我想我可以解决这个问题，但是我遇到了一个小问题。
如果我随后将报表文件发送给个人，两个文件之间的本地链接将丢失，因此转换数字肯定也会丢失。我能看到的唯一解决方法是发送包含转换率的文件以及声明，但如果可能的话我宁愿不这样做。
我希望您能理解我的问题，如果有人能提出解决此问题的建议，那就太好了！
I'm wondering if anybody can help?
I have a large number of Excel files. These are commission statements and some are converted from USD to UK Sterling, from UK sterling to Euros etc etc.
They are quarterly statements and at present I have to go through each file one by one and enter in the specific currency conversion rates for that month.
I was thinking it would be great if I could link all these statements to a single Excel file which contained the conversion rates. I could then update this single currency conversion file and all the other files would update.
I think I could manage this, but there is a little problem I have ran into.
If I then send the statement files out to individuals, the local link between the two files would be lost and therefore, surely so would the conversion figures. The only fix I can see would be to send the file containing the conversion rates along with the statement, but if possible I would prefer not to do this.
I hope you can understand my problem and it would be great if anybody could suggest any fixes to this!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
尽管这将包括费率的副本，但它是可更新的，并且仍然链接到费率源，但不完全依赖该链接进行计算。
我建议创建一个连接到存储这些值的文件的外部数据库查询。您可以将查询的属性设置为“不自动刷新”，这样用户就不会被提示这样做，这可能会让他们感到困惑。
这可能需要将您的货币汇率表设置为您自己的 ODBC 源，但随后您将可以控制适用的汇率。
将此外部数据查询结果表隐藏在工作簿中，并链接到这些单元格作为计算源。
也许这是错误的，但这并不是说您想要隐藏汇率本身，因为结果取决于它。您只是不想让用户的事情变得复杂。
Although this would include a COPY of the rates, it would be update-able and still be linked for you to the rate source, yet not completely rely upon the link for the calculations.
I would recommend creating an External Database Query that connects to your file storing those values. You can set the properties of the query to NOT refresh automatically and so the user should not be prompted to do so, which might confuse them.
This may require setting your currency rate sheet as an ODBC source for yourself, but then you will have control over the rate that applies.
Make this external data query result sheet hidden in the workbook and link to those cells as the source of your calculations.
Perhaps this is wrong, but it is not as if the rate itself is something you want to hide, since the results are dependent upon it. You merely want to not complicate things for the user.
我建议如下：
在目标工作表中，选择单元格，复制它们，然后简单地粘贴（仅限特殊值）。这对我一直有效。
I would suggest the following:
In the target sheet, select the cells, copy them, and then simply paste (Special-Values only). This works for me all the time.