导出到Excel时MS Project超链接丢失 [英] MS Project hyperlinks lost when exporting to Excel

问题描述

我使用MS Project 2010创建了相当长的项目。 它包含许多超链接。 当我尝试将其导出到Excel或任何其他格式时，超链接不会被传送。 我想我已经用尽了
MS Project上的各种选项，只需复制和粘贴（使用所有"粘贴特殊"选项），但没有成功。 重写超链接将是非常费力和耗时的，当然不应该是必要的。

I have created quite a long project using MS Project 2010.  It contains many hyperlinks.  When I try to export it to Excel, or indeed any other format, the hyperlinks are not carried across.  I think I have exhausted the various options on MS Project for doing this inclulding simply copying and pasting (using all the "paste special" options too) without success.  Rewriting the hyperlinks would be very laborious and time-consuming, and ought not to be necessary of course.

我担心这是一个"功能"。该软件并没有办法绕过它，但由于超链接信息显然是数据并且是文件的一部分，因此微软的民众或社区中的某些人可能知道这个狡猾的方式。  

I fear that this is a "feature" of the software and that there is no way around it, but since the hyperlink information is obviously data and is part of the file, perhaps the folk at Microsoft, or someone in the community, knows a cunning way around this. 

如果你能提供帮助，我将非常感激。

If you can help, I would be very grateful.

非常感谢

推荐答案

导出到Excel，超链接字段仅复制显示文本。如果您导出超链接地址字段，您将获得您可能期望的地址。但是我认为它以文本形式导出，而不是超链接。所以在Excel中你需要使用Hyperlink
函数将它从文本转换为工作的超链接。

Exporting to Excel, teh Hyperlink field only copies the display text. If you export the hyperlink Address field you get the address you were probably expecting. However I think it exports as text, not a hyperlink. So in Excel you need to use the Hyperlink function to convert it from text to a working Hyperlink.

这篇关于导出到Excel时MS Project超链接丢失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！