A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 1.29 seconds.
Search: Posts made by: Bill Manville
Forum: Links and Linking March 31st, 2010, 12:07 AM Posted to microsoft.public.excel.links
Replies: 3
Views: 1,801
Posted By Bill Manville
Hyperlink To A Specific Worksheet in Excel 2007

They all work to me (from Word, as I don't have FrontPage).
You did leave out the \ before the # ?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Forum: Links and Linking March 30th, 2010, 08:01 AM Posted to microsoft.public.excel.links
Replies: 3
Views: 1,801
Posted By Bill Manville
Hyperlink To A Specific Worksheet in Excel 2007

Try
..\filename.xlsx#worksheetname!A1

and, it the worksheet name contains a space, put it in quotes
..\filename.xlsx#'worksheet name'!A1

or use a defined name
..\filename.xlsx#rangename
Forum: Links and Linking March 12th, 2010, 06:19 PM Posted to microsoft.public.excel.links
Replies: 3
Views: 1,568
Posted By Bill Manville
Compatibility

Robert wrote:
I think that also the add-ins
need to be recompiled in 64 bit Visual Studio as well.

COM add-ins - I believe you are correct.

Bill Manville
MVP - Microsoft Excel, Oxford,...
Forum: Links and Linking March 11th, 2010, 07:32 PM Posted to microsoft.public.excel.links
Replies: 3
Views: 1,568
Posted By Bill Manville
Compatibility

Robert wrote:
Will it be possible to open files created in Excel 2010 64 bit with Excel
2007 ?


As far as I know the main compatibility issues relate to non-Office OCX
controls and API calls....
Forum: Links and Linking March 10th, 2010, 12:49 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 457
Posted By Bill Manville
Link from Word to cell in Excel

Edit Copy in Excel
Edit Paste Special Paste Link in Word

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Forum: Links and Linking March 3rd, 2010, 08:35 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 407
Posted By Bill Manville
Some Hyperlinks not Working in Excel 2007

I don't know what the issue is with the Kohler site, but when I tried
the link you posted in your message it got no response in Internet
Explorer. The problem, I think, is with the site and not...
Forum: Links and Linking March 2nd, 2010, 12:45 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 307
Posted By Bill Manville
Launch Program then load file

I guess you need to have an application installed that plays MP3 files.
I have never used an MP3 file so I don't know what application to
suggest.

Bill Manville
MVP - Microsoft Excel, Oxford,...
Forum: Links and Linking February 24th, 2010, 08:44 AM Posted to microsoft.public.excel.links
Replies: 2
Views: 357
Posted By Bill Manville
Excel 2007 link is invalid after referenced book is replaced

I seem to remember someone else remarking on links to workbooks
generated by a non-Excel package having problems like this.

If you open the new Inventory.xls in Excel and save and close it, does...
Forum: Links and Linking February 12th, 2010, 11:51 PM Posted to microsoft.public.excel.links
Replies: 2
Views: 408
Posted By Bill Manville
change program that hyperlink opens with

Have you tried checking the file association for JPEG files in Windows
Explorer (or My Computer) Tools Folder Options File Types JPEG:
Change

Bill Manville
MVP - Microsoft Excel, Oxford,...
Forum: Links and Linking February 10th, 2010, 09:27 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 378
Posted By Bill Manville
hyperlink to directory folder while highlighting filename

I don't think it's possible.
What is your objective?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Forum: Links and Linking January 14th, 2010, 12:18 AM Posted to microsoft.public.excel.links
Replies: 2
Views: 288
Posted By Bill Manville
spreadsheet links

Patti

What Dave has said is correct.
However, if you want to check a particular drive for files that link to
your file I can send you a utility that will do it (slowly).

Just email me at Bill...
Forum: Links and Linking January 11th, 2010, 12:05 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 298
Posted By Bill Manville
Link 2 sheets as same as linking cells

I already answered your previous post.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Forum: Links and Linking January 10th, 2010, 09:37 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 311
Posted By Bill Manville
Link All cells of Sheet1 to All Cells of Sheet2

In my opinion there is no good way to achieve what you are asking.

I suggest you consider the following options:
- 1) don't keep a separate sheet showing all the data; just remove the
filter from...
Forum: Links and Linking January 9th, 2010, 02:48 PM Posted to microsoft.public.excel.links
Replies: 3
Views: 273
Posted By Bill Manville
Error referencing linked dynamic range

I would think it is the fact that the named range is dynamic.
You could put a Before_Save macro in the source workbook to define a
static range name equal to address the current range of...
Forum: Links and Linking January 8th, 2010, 11:52 PM Posted to microsoft.public.excel.links
Replies: 3
Views: 273
Posted By Bill Manville
Error referencing linked dynamic range

I think the only solution is to have both workbooks open.
You could have a macro in B open A read-only and make it invisible if
that helped.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No...
Forum: Links and Linking January 8th, 2010, 08:56 AM Posted to microsoft.public.excel.links
Replies: 3
Views: 262
Posted By Bill Manville
Hyperlink just one word in a cell?

I fear you are mistaken.

Having inserted a hyperlink in a cell you can change the character
formatting of all but one word to be black with no underlining so that
it LOOKS like only the one word...
Forum: Links and Linking January 6th, 2010, 07:11 PM Posted to microsoft.public.excel.links
Replies: 11
Views: 832
Posted By Bill Manville
Excel 07 breaking links

The solution I proposed was specifically for hyperlinks.
It won't have any effect on Excel (formula) links such as those you
describe.

Formula links are held as relative if the source workbook is...
Forum: Links and Linking January 6th, 2010, 09:12 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 325
Posted By Bill Manville
Linked Workbooks - change in file location

Does Edit Links Change Source, followed by saving the workbook not
work for you?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Forum: Links and Linking January 3rd, 2010, 11:51 AM Posted to microsoft.public.excel.links
Replies: 1
Views: 415
Posted By Bill Manville
copy & pasting same cell from different worksheets

Assuming all your Jan data is in column B of the summary sheet, and all
the Feb data are in column C etc....

I would create the formulas for Jan in the way you describe.
I would make sure that all...
Forum: Links and Linking December 24th, 2009, 08:50 AM Posted to microsoft.public.excel.links
Replies: 2
Views: 424
Posted By Bill Manville
appending master list data

If I were doing this I would start from the other end.
I would have a single master list with all the information about all
the members, including which district they belong to.

Then, when I wanted...
Forum: Links and Linking December 24th, 2009, 08:18 AM Posted to microsoft.public.excel.links
Replies: 2
Views: 425
Posted By Bill Manville
Updating links to add-ins

It probably decides that a recalculation is in order after it has
changed a link; that will recalc the UDFs in appropriate circumstances.

I would suggest getting Workbook_Open to call the...
Forum: Links and Linking October 22nd, 2009, 04:36 PM Posted to microsoft.public.excel.links
Replies: 11
Views: 832
Posted By Bill Manville
Excel 07 breaking links

If the links were originally to files in the same folder as the
spreadsheet (or possibly sub-folders thereof) then Excel will hold them
as relative links by default. So, when the spreadsheet gets...
Forum: Links and Linking October 13th, 2009, 07:48 AM Posted to microsoft.public.excel.links
Replies: 9
Views: 328
Posted By Bill Manville
Hyperlinks

Faceter wrote:
=HYPERLINK("611.1 NVQ Level 4 Strategy","Strategy")
611.1 NVQ Level 4 Strategy = filename in full


That first argument is not the filename in full - it lacks an extension...
Forum: Links and Linking October 11th, 2009, 10:35 PM Posted to microsoft.public.excel.links
Replies: 9
Views: 328
Posted By Bill Manville
Hyperlinks

Sure.
Put the full filename in the first argument and it will work.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Forum: Links and Linking October 11th, 2009, 03:18 PM Posted to microsoft.public.excel.links
Replies: 9
Views: 328
Posted By Bill Manville
Hyperlinks

You still have the arguments wrong.
The FIRST argument of Hyperlink is the filename you want to link to.
The second argument is what appears in the cell.

=HYPERLINK("C:\Temp\MyFile.doc", "My File")...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 03:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.