http://help.wugnet.com/office/Links-forum-33.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office/Reference-Worksheet-Location-web-ftopict1180073.html#3729488 By: rKeen - In Excel 2003 or less a hyperlink could be formed as: http://www.mysite.com/MyExcelFile.xls#MyWorkSheetName!MyCellReference to link to anywhere in a workbook. Excel 2007 always defaults to the first Worksheet and the worksheet location is stripped. Has any experienced this or have any knowledge as to why the reference is no longer valid? Thank you. http://help.wugnet.com/office/renaming-hyperlink-Excel-ftopict1179743.html#3728221 By: candyman - I want to put hyperlinks to my contacts' web bios in an Excel file, but I don't want the full file name so the sheet is easier to use. Can I rename the hyperlink to a smaller name in my excel document? http://help.wugnet.com/office/Excel-2007-data-link-update-prompt-ftopict1096662.html#3726786 By: Adam - would be a good idea to scrap this website and just provide a link to the MS newsgroups... whats the point really... if all users having problems go to one place then that is where they will find answers... not spread out over other worthless websites... Stampie url:http://www.ureader.com/msg/1033559.aspx http://help.wugnet.com/office/OLE-Powerpoint-ftopict1179322.html#3726261 By: xclicx - Hello, This is my first post here so I may have put it in the wrong section but from what I have read from the other posts, this should be it. I'm having a real headache with Power point's OLE, let me explain from the start : I've been working for the last three months on a program (in VB.Net) that updates Excel worksheets with raw data each month, does a lot of adding up ... http://help.wugnet.com/office/Automatic_updates_of_links_betwe-ftopict1150323.html#3722734 By: macropod - Depends on what the issue is. What is the problem you're having? -- Cheers macropod [Microsoft MVP - Word] "GuestionGuy" wrote in message news:11564BC5-F9B0-42C8-817B-F8BA4CF39218@microsoft.com... > Anyone find an answer to this? Office 2007 SP2 did not solve the issue for me. http://help.wugnet.com/office/Hyperlinks-Randomly-Change-ftopict1174474.html#3716901 By: LisaK - I'm also trying to figure out why a link is breking - 07 versions. "booker@mgt" wrote: > Steve, > Did you ever find a resolution. We have an 07 environment where the same > thing happens. > > For us, our network share is > > it's a CIFS/SMB filesystem on a Sun StorageTek 5320C NAS running NAS > > OS version 4.21 > > > "Steve" wrote: > > > Operating system is... http://help.wugnet.com/office/Embedding-linked-image-html-file-xls-file-ftopict1176697.html#3715436 By: marcd - I work for a company that does a lot of its business on an old Unix box. They put out reports in plain text format, and I decided to see if we could update the look by replacing the plain text formatting with some HTML tags. The Bosses liked it alot and asked me to go further with it and to include a company logo. I have no problems seeing the logo in excel if I open the .htm fil... http://help.wugnet.com/office/Links-updating-automatically-ftopict1156724.html#3711621 By: Ed - Hi I have exactly the same problem, I have links to an external workbook and they are not updating. I have checked all the settings to enable external links update with no luck but I noticed if I have the book that the links are pointing to open the links works. I beleive this is started when we installed the new Excel 2007. I hope someone can find an answer tho this iss... http://help.wugnet.com/office/Showing-hyperlink-lookup-ftopict1174472.html#3709183 By: Shane Devenshire - Hi, Excel's formulas return values, they will not return the associated hyperlink or comment or error checking message. You might be able to right a custom VBA function that will do this for you. Here is a sample, that doesn't quite do what you want but it might start you on the way Function RETURNHYPERLINK(Rng As Range) As String If Rng.Hyperlinks.Cou... http://help.wugnet.com/office/link-updating-workbook-open-ftopict1174705.html#3707003 By: ernremf - Hi, I have several files on a network server that contain links to a master file, also on the network server. I've set the Startup Prompt value for the link to "Don't display the alert and update links" with an automatic update, intending for the files to be automatically updated when opened. This works as intended when I open the files from PC #1. However, when I op... http://help.wugnet.com/office/Valid-Hyperlinks-reported-Invalid-ftopict1174473.html#3706175 By: Steve - Because of problems with hyperlinks randomly changing without any intervention a VBA procedure was written to perform various validation checks on the hyperlinks. One of the checks is to see if the link actually exist and if not report an error. Following is an excerpt of the VBA procedure: For Each h in Worksheets(curwksname).Hyperlinks If (Dir(h.Address) = ) then ... http://help.wugnet.com/office/Password-Protected-Links-ftopict1173313.html#3706173 By: Brenda from Michigan - Thank you. I will pass it along and see if it works. "Michel Angelosanto" wrote: > try > http://login:pass@the link > > "Brenda from Michigan" a > crit dans le message de > news:59F70E27-1012-46EA-845A-3FEC2167BE9A@microsoft.com... > > User has Excel 2002 SP3 > > > > His workbook has multiple links to ot... http://help.wugnet.com/office/Setting-Excel-sheet-automatically-determine-employee-ftopict1174333.html#3705658 By: Enda80 - Perhaps a What-If analysis would help with this, but the situation that presents itself: For retirement plans, usually a person must work one year of 1,000 hours before that person can enter into the retirement plan as a participant. However, plans usually have set dates of entry, usually twice during the year. Therefore, a person enters on one of those entry dates subseque... http://help.wugnet.com/office/saved-files-loses-hyperlinks-ftopict1173666.html#3703323 By: Joan - We have an Excel spreadsheet on our network with working hyperlinks. One user moved it to his folder (still on the network) to make some changes. The hyperlinks still worked at this point. When he was done with changes, he did a "file save as" back to the original network location but the hyperlinks no longer work. I have looked at Security and drive mapping but cannot fi... http://help.wugnet.com/office/Fast-Money-ftopict1172953.html#3700635 By: You Need Fast Money??? - You Need Fast Money ?????, visit http://dinero4ever.blogspot.com Now!!! http://help.wugnet.com/office/Excel-LOOKUP-ftopict1172547.html#3699206 By: Lars-Åke Aspelin - On Mon, 15 Dec 2008 12:05:25 -0800 (PST), ritpg wrote: >I have a need to do what I believe is called a two dimensional >search. I want to populate a cell with the contents of a cell that >exists at the intersection of a row and column each of which contains >a known value. > >I've come to the conclusion that a combination of the HLOOKUP and ...