链接到Sharepoint Excel的特定工作表/单元格 [英] Link to an specific Sheet/cell of a Sharepoint Excel

问题描述

我有一个Excel工作簿上载到我的Sharepoint网站.我想创建一个指向该Excel的http链接，但我要指向特定的工作表和单元格，因此Excel会在该位置打开.

I have an Excel Workbook uploaded to my Sharepoint site. I want to create an http link to that Excel but I want to point to an specific Sheet and cell, so the Excel opens at that position.

在以下链接中，我找到了如何引用工作表的方法: http://support.microsoft.com/kb/197922

At the following link, I found how to reference a sheet: http://support.microsoft.com/kb/197922

因此，我建立了这样的http链接:

So, I built my http link like this:

<a href="http://SharepointSite/MyWorkBook.xls#Sheet2!D4">

但是，Excel在工作表1，单元格A1上打开.不是Sheet2，单元格D4

However, the Excel opens on Sheet 1, cell A1. Not Sheet2, cell D4

为什么这不起作用?有什么方法可以打开在特定工作表/单元格中在共享点上载的Excel?

Why is this not working? Is there any way to open an Excel that is uploaded at sharepoint in an specific Sheet/cell?

作为附加信息，该链接位于Sharepoint网页内.因此欢迎其他选择！

As additional info, the link is located inside a Sharepoint Webpage. So other options are welcome!

谢谢

推荐答案

这也适用于同一文档中从一个单元格到另一个单元格的超链接.通过消除文档名&中的所有空格(用下划线替换)，避免了这种情况.标签名称.

This also applies to hyperlinks from cell to cell in the same document. I got around this from removing all the spaces (replaced them with underscores) in my document name & tab names.

这篇关于链接到Sharepoint Excel的特定工作表/单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！