BETTER WITHOUT ADS? Become a voluntary supporter

Welcome To Fetcheveryone

Our awesome training log doesn't hide its best features behind a paywall. Search thousands of events, get advice, play games, measure routes, and more! Join our friendly community of runners, cyclists, and swimmers.
Click here to get started
Already a Fetchie? Sign in here

SpreadEveryone: The Fetchland Excel wire

85 watchers
17 Mar
5:44pm, 17 Mar 2021
4748 posts
  • 0
run free
Quimby - use the Hyperlink feature:
1. Right-click on a cell and find the Hyperlink command on the short cut menu
2. Navigate to the file
3. Click on the Bookmark button on the right of the Hyperlink dialog box and select the sheet you want the hyperlink to be connected with

Should end up with something like:
--NetworkLocationFolderFileName#'SheetName'!CellReference

Where the -- is a double backslash
17 Mar
5:45pm, 17 Mar 2021
4749 posts
  • 0
run free
--NetworkLocation-Folder-FileName#'SheetName'!CellReference

- is a single backslash
1 Apr
7:46am, 1 Apr 2021
4739 posts
  • 0
quimby
A belated thank you to all, but I have not been able to get this to work. Permutations attempted were:

\fileshereusers$quimbyJobs2.xlsx#'Sheet1'
\fileshereusers$quimbyJobs2.xlsx#'Sheet1'A1

It was always a long shot getting it to work from outside Excel. Ah well.
1 Apr
4:41pm, 1 Apr 2021
4758 posts
  • 0
run free
In both variations the $ should be a backslash
Also should have double backslash before the fileshereusers

After the sheet name you need an exclamation mark ! and then the cell reference, i.e. 'Sheet1'!A1
2 Apr
3:50am, 2 Apr 2021
4740 posts
  • 0
quimby
Fetch has stripped the double backslashes, and the single backslash before "quimby". It's a $ share because it's a Windows home drive. I'll try it with the exclamation mark when I'm back at work :-)
um
2 Apr
8:29am, 2 Apr 2021
4485 posts
  • 0
um
I think it also needs to be 'no spaces' in the file or sheet name. And (I thought, as per web), no need for the inverted commas?

Got something to say?

To contribute to the discussion, you need to either sign in or register as a user.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work

Back To Top

Close