Windows Support Forum

# File:// protocol in excel, word - "Hyperlink" redirecting changes

Q: File:// protocol in excel, word - "Hyperlink" redirecting changes

clicking on "file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141" in excel redirect to browser but omits "file:///" &"?3/4/3141" portion from the hyperlink thus doesn't open in the browser. how can I let excel redirect file:// protocol without modifying the link

I am cross posting due to time constrains and due to that no one is responding and due to the fact it is a difficult issue to resolve. and I promise when I get it solved I will notify you promptly.

Relevancy 100%
Preferred Solution: File:// protocol in excel, word - "Hyperlink" redirecting changes

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

Relevancy 99.51%

clicking on "file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141" in excel redirect to browser but omits "file:///" &"?3/4/3141" portion from the hyperlink thus doesn't open in the browser. how can I let excel redirect file:// protocol without modifying the link

Relevancy 77.4%

Office Pro i excel is inserting in hyperlink word pasted row which have a worksheet which has cells A C copied and pasted into word as RTF link all is good and the numbers update as required here is my problem the rows have data containing each month for the current year now when we start a new year i would like to insert a inserting excel row which is hyperlink pasted in word row in excel so that i can add each additional month however i do not want to have a bunch of extra rows to be used for just in case then i need this extra row to show up in the word document for inserting excel row which is hyperlink pasted in word which it is linked now here is the bigger problem when i go to the word document and select update link it will insert the new row i put in but it will push the last row of the word document how can i do this so that my all the rows that i want will be visible i e not be pushed off thanks nbsp

Relevancy 76.54%

In Excel 2010 sheet 1, I enter document name "Text.doc or docx" into column A1 cell. Is this possible the sheet1 A1 cell could auto search "Text" document from sheet 2 at column A "k:\project base\text.doc" if match on that hyperlink then auto open "text.doc" file.Thanks for your help again.

A:Auto open word document in Excel hyperlink

Not sure I understand what you want to do.For a Hyperlink to work you must manually click on the Hyperlink.MIKEhttp://www.skeptic.com/

Relevancy 73.96%

Is it possible to create a hyperlink in an excel spreadsheet that goes to a SPECIFIC FILE within a zipped file? If so, how do you do it?

Thanks!

BL

Relevancy 72.67%

We have an old MS-DOS program that runs from a batch file. When I try to access the program by clicking on it's hyperlink in an Excel spreadsheet, the program does not load (you can see the command line screen briefly, but it disappears). I can load the problem without any problems from it's network location, so I know the program is working. What is preventing the program from working/loading in Excel?

A:Cant' access batch file via hyperlink in Excel

Can you access the file using a hyperlink on a html?

Relevancy 72.67%

I am trying to create a macro that will look at the contents of a cell and insert it into an address on the server. For example, the contents of the cell is: folder\file

The location to hyperlink to is: \\server\share\folder\file.doc

I need to keep the file extension in the macro so that clicking the link will automatically open the file. I just need to get the contents of the cell to fill in the folder name and file name.

Relevancy 71.81%

Hi Guys,

I need a help with excel macro's.

I have a excel file with a set of hyperlink(to open a XML file). I need the data's in all the hyperlink (.XML file) in an excel format.

Thank You

A:VBA Code to open a XML Hyperlink and convert to Excel file

I'm a little confused can you post your xl sheet?

Relevancy 71.38%

Unable to open Microsoft Office documents(excel,word) in Internet Explorer when we enforce strict TLS 1.2 protocol (Disabling SSL v2,SSL v3,TLS 1.0, TLS 1.1)on the webserver. We tested by removing strict TLS 1.2 and IE is able to open the document fine.
Error description : We see a Microsoft Excel Security Warning with the following content.
Certificate error

When we disabled SSL V2 and SSL V3, the document opens fine but when TLS 1.0 is disabled we are seeing the  pop-up with certificate error. We tried to open the reports in CSV format, 2007 format and 2003 format and all of them have the same issue. Does
Internet Explorer have any restrictions when TLS 1.2 is strictly enabled ?

Note : We are able to download the document using Internet explorer and the document opens fine from local but opening the document from the browser fails with certificate error.

https://social.technet.microsoft.com/Forums/en-US/9bfa6b18-6ae3-427a-9fe1-0ede15f97875/unable-to-open-microsoft-office-documentsexcelword-in-internet-explorer-when-we-enforce-strict?forum=ieitprocurrentver
Relevancy 70.95%

In Word 2000 under Insert Hyperlink, Word maintains a listing of recent files or browsed pages that you can use to insert hyperlinks into your document.

Is there someway to "flush" that list, when it become so long or so outdated as to begin to lose utility for the end-user? There must be some way to do that, since I noted that my files list (either at home or work) recently was zeroed out in the last couple of weeks or months.

A:Deleting File Locations Under Insert/Hyperlink in Word 2000

Okay, we have at least a partial answer to this question. Apparently if you flush your recently visited internet page history from your default browser, you will simultaneously delete the recently browsed pages under Insert > Hyperlink in Word 2000.

We're still in the hunt for information on how to deleted a list of the file locations that is also retained under Word 2000. Other entries?

Relevancy 65.79%

Hello all I have been help results needed new form Macro a Word/Excel to Word file... export to presented with a project that involves Forms that I am not able to resolve Basically I have been asked to create a document template where other team members can fill out a form that asks a series of questions then to have only the completed form results export Macro help needed to export Word form results to a new file... Word/Excel to a new file I am aware that Word can export the form Macro help needed to export Word form results to a new file... Word/Excel results to a text file but when I do this all of the questions that were on the original form are exported to the new file What we are looking to achieve in the end If the end user is faced with questions but only of the questions pertain to the end users project only the completed form fields will export to a new file I know that this should be possible with using a macro button to export the data but that is where I need the help I tried searching for this exact situation but I did not find any matches hence the new thread Thank you in advance Bill nbsp

A:Macro help needed to export Word form results to a new file... Word/Excel

Relevancy 65.36%

I have an Excel Workbook where I try to embed a Word and Excel file (icon). But, I cannot open the file afterwards. However, my colleagues can open it when I sent it to them by email. What could be the problem with my application.

I tried disabling my spyware software and reloading Microsoft Office XP but the problem is still there,

What could be the problem?
Thanks a lot

Relevancy 64.93%

I have hyperlinked to a .wav file in an MS Word 2007 document, and the sound file plays without opening a media player.

Problem is the sound file is 10mins long, and I have no way of controlling the .wav file once I have activated the hyperlink.

Pressing escape stops the sound, but I cannot pause or rewind.

The hyperlink seems to be opening the sound file as an 'embedded' object that I have no control over.

During a presentation, I need to be able to pause the sound or even rewind it.

Why doesn't MS Word allow me to open the hyperlinked sound file in a media player?

Can you help?

Berserk.

Relevancy 64.5%

This problem is on excel 2003. This is the error that occurs and I have no idea how to correct it. I create a hyperlink in excel and then click on it and get this error:

Hyperlink unable to open. No program is registered to open this file

Anyone?

Relevancy 64.5%

In excel 2010, I entered "=HYPERLINK(VLOOKUP(B3,CTO_DB!A1:B1001,2,0),B3)". How can I make it auto open the file if hyperlink is exist? Thanks

A:Auto open word, excel and pdf file in excel

It is a bit complicated, using LOOKUP with HYPERLINK,see here for an explanationhttps://stackoverflow.com/questions...MIKEhttp://www.skeptic.com/

Relevancy 62.35%

Hi Tech Guys,

I needed support for corrupted and excel files, do you know any best word and excel corrupted recovery software? i recovered a deleted word and excel file, but when i opened it some are okay and some are corrupted.

http://www.techsupportforum.com/forums/f10/corrupted-word-and-excel-file-from-a-recovered-deleted-file-425230.html
Relevancy 61.06%

Hey all,

I have come to you in a fit of desperation. My USB drive was stolen recently and my master Excel data file was lost, which contained all my compiled data from my most recent lab experiment.

Anyway, I have charts of all the important stuff in a word document. The data is there, I can hover on each data point and see the values, and the axes and chart are all accessible for editing.

My question is, how the heck do I extract that data back out of the chart into a table or Excel spreadsheet? There MUST be a way that is better than copying down each data point one at a time

A:Excel chart in Word 2010: extract chart values? Lost Excel data file!!!! Help.

Hi welcome to the fourm.
I don't know it reverse engineering is possible.
Something like convert chart to table?

One thing you could try is copy the chart back to a new Excel file and see if more is possible there than in Word?

Like I said never needed this. Have you googled for something like Excel data reverse enginieering?
Maybe something come up.

Relevancy 59.77%

I am still running Windows XP with Office 2007. Suddenly neither Excel or Word will automatically open existing files when I click on them from windows explorer. I can go to the Open option in the menu bar for Excel or Word, select the file to open and it will then open properly. Are there any option settings that allow for the files to open when click on them? I do not receive any error messages nor does the event viewer provide any error messages.

A:Excel / Word File Opening

does it give any error messages

in the file manager
do you have the word/excel icon next to the file ?

if you right click on the file - do you get an "open with" option

have a read here - see if the file is associated with the program

Relevancy 59.77%

Whenever i click on a recent excel or word doc, the program opens and gives me a warning saying i already have a file of that name open, but i dont..... Im running windows XP.

Relevancy 59.77%

I'm trying to insert from Word into Excel using Insert-Object-Create From File.

The tab I'm inserting it into is set up correctly (in this case Landscape Legal). But when I view, it only has the first page (of two) from the Word document. I've given it enough space page break wise.

Is there a better way to do this than my first idea (insert one document for the first page, and another for the second)?

A:Insert File From Word into Excel

I know it seems it should work, but it doesn't. I'd just copy and paste special between Word and Excel. In Excel, use Edit | Paste Special | Text.

Select All in the Word doc. In Excel, widen column A, format to wrap text, and do the paste special | text.

Not as quick as Insert | Object, but it works.

Relevancy 59.77%

Excel cannot open the file " " because the  file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches.

Files got corrupted at time of virus removal. also have and use Carbonite backup if that helps.

Open MS Excel in your system.
Click on File tab > Open. Or press Ctrl+O.
Locate the corrupted XLSX file and select it.
Click on the arrow shown beside the Open button.
Click on Open and Repair in the list.
Still wont open files, any help would be appreciated

A:Excel and MS Word "cannot open file"

Uninstall/reinstall MS Office...update for all SPs...update for all critical updates.

Then try.

Louis

http://www.bleepingcomputer.com/forums/t/558798/excel-and-ms-word-cannot-open-file/
Relevancy 58.91%

Microsoft Word stops working and goes into a restart mode whenever trying to paste an information taken from an Excel file which was copied to clipboard into a Word File

A:word restarts when pasting file from Excel into it

an Excel file which was copied to clipboardIs it just Excel or does anything copied into the clipboard cause the problem?Try starting Word is Safe Mode:Click StartClick RunIn the Run box type: winword.exe /aThe command line switch /a starts Word but prevents Add-Ins and Global Templates from being loaded automatically.Try pasting and see if it works.MIKEhttp://www.skeptic.com/

Relevancy 58.91%

Recently, when I open either my MS Word or Excel programs, and click on the yellow "Open" folder, whereas previously a list of my saved documents came up, now sometimes the page is blank! If I leave it for, say, ten minutes, they appear and I can open and work on them, but I wondered whether anyone had an idea as to why this is happening? I am running Windows 7 (64 bit). Many thanks.

Relevancy 58.91%

not sure why this happened, but I cannot open these programs,
I tried all the discs I have for my laptop, with no luck?

how do I get them working and why did it happen?

http://www.techsupportforum.com/forums/f10/excel-word-not-working-now-needs-sberet-file-301873.html
Relevancy 58.91%

I lost a few hours of work due to:
Suddenly unable to save a file in Excel. No warnings etc. Blissfully working (and saving) along but when I boot up again later I found the file 'not saved' but a random number file eg; BDF45000 in directory. Opens up in Excel but with only some data.

I did:
Run repair, Office 2003 Proff. (No change)
Check for 'read only' (Not the problem)
Use Reg Mechanic, cleaned up and defragged... (No change)
Save under different name. (No change)

I use AVG... could it be that a third party app interferes with a 'proper save'?.. or AVG interference whilst excel tries to save? I am a bit paranoid at this stage... not trusting the pc. Ideas?

Relevancy 58.91%

I have tried an easier way to copy contents of an excel spreasheet into Word .doc.

Using this site I have found that in Excel copy one large range and Edit-> Paste Special ->
Microsoft Excel Worksheet Object, and this will copy text and tables to Word.

One problem is that the backgound cell lines in Excel also get copied. How can you remove those, in Excel I presume before the copy.

Here is an example.

A:Copy Excel file info into Word

See Tools > Options > View > Window Options.

Relevancy 58.91%

Hello,

I am looking for a reliabe file (mostly Excel and word files) vault for Windows 7. I have not found anything at the moment.

Thanks a lot,
daniele

A:File (excel and word) vault for windows

Need some help here "reliabe file ... vault" - - what do you mean - - what does a vault provide for you?

http://www.techspot.com/community/topics/file-excel-and-word-vault-for-windows.191920/
Relevancy 58.48%

I have Office 2003 with a Vista operating system. Everytime I try to do a mail merge to create label with a Excel csv file it forces me to close the application.

I can complete the mail merge using the same file on any other computer. The only why I can get the mail merge to work is to save a csv file as a regular excel file. It doesn't matter what csv file I try on, it just crashes word.

Tried unistall and re-install of Office and the problem is still occuring.

I don't know why word won't allow me to use th csv file type.

Relevancy 58.48%

my system vista save, work cannot Excel word can create file not Ultimate Office all updates no viruses GB RAM GB HDD C D Problem I used to have office At some time word could not save anymore so I switched to office thinking it is related to vista when I start word I get the error message quot could not create work file check the environment variable quot At first Excel can not save, word cannot create work file it wouldn't save either but I fixed that by deleting the Excel can not save, word cannot create work file normal dot It seems to work besides the annoying message The other problem may be related Excel can not save at all and crashes while trying and says quot MS Excel cannot open or save any documents because there is not enough available memory or disk space to make memorey free quot all other Office applications seem to work well haven't tried too much I googled and tried all the registry tricks that's how I found the fix with deleting the normal dot I suspect at some time I changed something and can't remember what but word worked at some time I have reinstalled Office multiple times deleted registry entries etc Nada My links to the temp folders in environment variables should be correct I had meddled with those at some point I searched the forum haven't found anything Sorry in case I overlooked something here Edit I have the swap file size on quot automatic quot despite GB of RAM I only have one account administrator

A:Excel can not save, word cannot create work file

No one an idea? It happens in outlook too. but not when i start it, it sporadically pops up that it can't create that work file.
I really googled around and could at least solve it so that i can save in word, so i really tried before asking.

http://www.vistax64.com/software/212859-excel-can-not-save-word-cannot-create-work-file.html
Relevancy 58.48%

A:Word / Excel Crashing When Clicking File->open

Hello and welcome to BC.Sorry for the delayed reply. Nothing suspicious in the log.

http://www.bleepingcomputer.com/forums/t/108290/word-excel-crashing-when-clicking-file-open/
Relevancy 58.05%

I have a many-page document in Word 2002. Is there a way I can use a hyperlink to jump to a different page? It looks to me like I can only hyperlink to the top of the document, a footnote, or headings.

Any help would be appreciated.

Don

Hi,

To the best of my knowledge, you can only hyperlink to another section of the same document if the area you wish to hyperlink to is a heading text (as opposed to normal, etc) or a bookmark.

Highlight the area you want to be the hyperlink.

1. You can either right click your mouse or click insert on the top menu bar.
3. Choose the 'place in this document' button on the left hand side of the hyperlink window.
4. You will be offered a choice of subjects you can link to.
5. Click the subject that you want to link to.

Relevancy 58.05%

I am not very good at programming and I need to create a script for executing the following function. I wish to create an "Automatic hyperlink creator for word 97"
I want to do the following task:
Automatically select bookmark for selected text and give hyperlink for that text so replacing manual work that consists of: if bookmarks are created, we search for specific text where we have to put hyperlink and then select the text and give the hyperlink.

Thanks
PeterPan

I'm not sure I understand. If you could give me the scenario, I might be able to help better.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench

Relevancy 58.05%

I am having a goofy problem with .doc and .xls files. If I attempt to open them from either Windows Explorer or My computer, I get the "This file is already open" error but then you can then change the file and save it.
However, I can then execute the application and open the file from within the app, it works fine and doesn't give the error.
Any help would be appreciated. I have found traces of this error on the internet but have not found any satisfactory solutions to it. Thanks

A:"File Already Open" when Word or Excel file opened with WinExplorer or My Comp

Have you tried closing word then clicking start/run and typing

winword /regserver

Type this one for excel.

excel /regserver

Relevancy 58.05%

Hello,

I have a hyperlink in an Excel spreadsheet pointing to a jpg on my hard drive. ACDSee is my default program to open jpg's but when I click on this hyperlink, the jpg opens in Internet Explorer 7.

Any ideas how I can get the hyperlink to open in ACDSee, please?

Best wishes,

Tim.

Relevancy 58.05%

I have a question regarding Hyperlinks in excel.

I have the hyperlink names in a column. i.e. ID no. which is the display name for the link.
The link then points to a site for that ID number.

I know that if you highlight the display name & Right click, you have the hyperlink option, you can then copy the hyperlink and paste it in a new column, so that it displays the actual link, which is what I would like to do.

However, I have hundreds of the display names in this column, I'd rather not have to do this on each one.

Is there away I can highlight all of them and extract the actual link to a new column?

Any help/suggestions would be appreciated.

Thanks

Relevancy 57.62%

Hi,

Recently, I'm having slow file loading while opening ms word files and excel files directly from windows explorer. It takes a minute to load, however it opens immediately if I open .doc files or .xls files directly from their application software. It also take a minute for MS Word and Excel software to shut down.

I have run my antivirus (Symantec) and MBAM but they all show no virus was found. I'm not sure what should I do next, please advice.

A:Microsoft Word & Excel - problem with opening files in Word and Excel

What version of Word & Excel?

http://www.bleepingcomputer.com/forums/t/303338/microsoft-word-excel-problem-with-opening-files-in-word-and-excel/
Relevancy 57.62%

Hello all,

I needed some help here, one of my friend having the problem which is his microsot word or excel files open in read only file.

He using Windows Vista and Microsoft Office 2007.

Anyone here can help me on this?

Thanks

A:microsot word or excel files open in read only file

Relevancy 57.62%

Recently used file list has become unavailable in Word 2002 and XL 2002.

I'm using Win XP Professional

Tools/Options/GeneralTab/Recently Used Files

is greyed out.

Don't know what caused it. Perhaps something in Power Toys For XP TweakUI.

Would like to get it back

A:Recently used file list unavailable in Word and Excel 2002 (Win/XP)

Hi

>>>>Don't know what caused it. Perhaps something in Power Toys For XP TweakUI.<<<<

In weak ui under the parnoia tab is an option to clear the recently open'd or used files.

I did'nt know tweak could extend this function to app's other than windows .

did i help or just confuse you futher
Lon

http://www.techsupportforum.com/forums/f10/recently-used-file-list-unavailable-in-word-and-excel-2002-win-xp-3996.html
Relevancy 57.62%

This problem has probably been addressed here before, but I haven't found it, so will ask it again. Word is supposed to allow data access from other files types such as Excel and Access, for mail merge source and other file linking. These file types are not recognized by Word. If I try to open an Excel file as a data source, all I get is a text file with garbage and a message box asking how to convert it.
Using Office 2003 with all patches and fixes. OS is Win2K with all patches and fixes.
I suspect it is a problem with OLE or DDE, but I don't know how to track it down. I've tried repairing the Office installation with no success.
Thanks for any help.

Relevancy 57.62%

Hi I m trying to figure out how to make it so that a very long checklist which includes checkboxes and text boxes can be transferred to excel I m working with the Microsoft Office suite I ve been reading about how you re supposed to enable the quot Save Data as Delimited Text File quot in the advanced part section of the Tools Options tab and then save it as a text file to import into excel but when I do that it doesn t save any information just two zeros I ve been looking at other forum questions and messing around with how the forms are protected or not but I can t get it to actually save any of what s entered in to the forms when I save it as a text file Any help on this would be very much appreciated I ve attached a zip folder I hope with a section of the checklist in case that might help Thanks so much nbsp

Relevancy 57.62%

I would like to embed FREE/Non-Licensed fonts in Excel & Word documents. How?

Joe

Relevancy 57.62%

All My files (word & excel & pdf & RAR file .... )extension changed to .irjhhvh
the file name become filename.Doc.irjhhvh or filename.pdf.irjhhvh
OS: Windows 7

Relevancy 57.62%

Relevancy 57.62%

I have inserted a "Top of Documrnt" hyperlink in a document but am unable to activate it.
The only way it will avtivate is to rightt click and select "Open Hyperlink".
Please advise how to get it to activate by clicking it or passing curser over the hyperlink. TKS BOB A

you will probably get better / quicker responses,
.
just click: report
type in: move to business applications

Relevancy 57.62%

Hi,
I want to have a phrase with an associated hyperlink connected to it (in Word doc) that the reader can click on without having to hold down the control key. What's the best way to do this?
Thanks.
Also, if there is a better part of the forum for this question I would appreciate any help on the redirect. Thanks.

Select
"Tools"
"Options".
from the Tabs click the "Edit" tab.
Press "OK"

the phrase you have in word
highlight
then
insert
the phrase should be at the top of the box
and atthe bottom you type in the url

probably better in the business applications forum as a word issue - i'll move

Relevancy 57.62%

Would be grateful if anyone could advise on a problem with Word hyperlink jpg nothing does 2003 hyperlinks in Word Win XP - I have created standard hyperlinks to various files doc avi and jpg in a Word document The doc and avi files display with no problem when clicked on but nothing much happens when I click on any of the links to jpegs The cursor briefly shows the hourglass so it is doing something but then it reverts to the pointer and that is it I am sure the pathnames are correct - and if they weren t Word would display Word 2003 jpg hyperlink does nothing an error message It seems to be failing to launch the associated viewer Windows Picture and Fax Viewer intially or perhaps not even trying If I double-click on any of the files in Windows Explorer they are displayed with no problem I have tried changing the associated application to Paint for instance and again the images open with no problem from Explorer but nothing Word 2003 jpg hyperlink does nothing happens if I click on the corresponding link in Word This is computer-specific because if I open the same document on my laptop and click on on a links to a jpg it opens in Internet Explorer One thing I am wondering is whether Word ignores the normal file extension association and makes its own choice about which viewer to use Other than this I cannot see why the jpgs should fail to display Have searched the internet quite thoroughly and failed to find a reference to this problem with Word It is a fairly high spec PC without other known glitches nbsp

Relevancy 57.19%

I have created excel file which contains group of pending amount in master sheet and backup for that amount is in other sheet I need to write a macro for this For example in master sheet I have hyperlink. for in creating Excel Help Need Rs in Column P say P amount only in Column P The Need Help in Excel for creating hyperlink. back up for this amount available in another sheet say it is in pending detail sheet column C C If I run the macro from the backup sheet it should take the amount of selected cell and search the amount in master sheet After finding the amount it should create link between master sheet Cell and backup Cell Link should be displayed in next column both master and backup sheet Possible Problem - Master sheet may contains same amount in the column- The suggestion for this problem is like creating a link for the cell which doesn t have hyperlink Hence it shouldn t Need Help in Excel for creating hyperlink. take a cell if it is having hyper link nbsp

Relevancy 57.19%

I am having a problem removing hyperlinks from Excel-the problem is that every time I remove a hyperlink in one cell, hyperlinks appear iand multiply in other cells. Eventually, nearly all cells are hyperlinked. I have copy and pasted (as value only) on a new worksheet only to have the same thing happen in a short time. Is there anyway to mass eliminate hyperlinks? Is this a program bug?

Relevancy 57.19%

I am trying to create a hyperlink from an excel spreadsheel to a folder on our network drive. Everytime I go to create the link it locks up trying to see the network. This doesnt happen when I am just browsing the network through explorer. Any ideas if there may be a setting in excel that needs to be changed?

Thanks!

I assume you are using Windows Vista or W7.
What I have noticed in Ms Office that when you link or want to browse to a network drive or drives explorere freezes up, I let it wait and after app 5 minutes something happend.
I looks like some timeout issue when reading the available mapping over the network, each mapping takes about 15-20 seconds so start adding up!

I generally kill the process and restart it and then it works instantly. In my cxase office 2003 so I am guessing it's a Vista/7 issue.

I don't have any solution for it (yet)

Relevancy 57.19%

I want to be able to enter a number in a cell and have it automatically become a hyperlink to a row on another worksheet in the same workbook. Say I enter "23" then whenever I click that cell it will take me to row 23 of the other worksheet. Thanks in advance.

I think what you're asking is doable in VBA. But with a little compromise- can be esily achieved with a simple formula. The compromise being that the hyperlink will be an adjacent/another cell and not the actual cell in which you enter the row number for your jump-to location.

Say you enter the the row number you require in cell sheet1!D3, then you could have the hyperlink in sheet1!E3 containing the formula

=HYPERLINK("#Sheet2!" & D3 & ":"& D3,"Row number " & D3)

which would take you to the desired row number in worksheet 2.

Hope this helps. Get get back if you want to rack some brains on the vba solution.

Relevancy 57.19%

Hello

I am very new to using Macros but I am trying to create a new one that creates a new hyperlink and new file when ever a cell in column A has a value put in it.

What I would like is for the MAcro to take the Value of A1 and impose that value into the name of the new document (which would be created as part of the Macro), which is then shown as a hyperlink in A1.

This process could then repeat down the rows.

Would this be possible?

Thank you

I made this a few years back, you will need it to convert to hyperlink, and you can use the references to adapt to to your code.

you should use the recorder first to establish a base of what you are trying to do, then adapt.

Code:
'
' 7/18/2007 by Ziggy
'
Application.ScreenUpdating = False

Dim hyper As String ' hyperlink variable
'
Dim endrow As Integer
Dim RowX As String ' Cell to change
Dim RowC As Integer 'row Counter
Dim wb As Workbook
Dim ws As Worksheet

Set wb = ThisWorkbook
Set ws = wb.ActiveSheet

endrow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row

RowC = 1

Do Until RowC > endrow

RowX = "A" & RowC 'Modify Letter for Column

Range(RowX).Select

If Range(RowX).Value <> "" Then ' skips cell if blank

hyper = Range(RowX).Value
hyper _
, TextToDisplay:= _
hyper

End If

RowC = RowC + 1

Loop

Application.ScreenUpdating = True

End Sub

Relevancy 57.19%

I have a question on adding a hyperlink from my intranet website to an excel worksheet:
The actual complete workbook is located on a LAN folder on our computer system... I want them to be directed to a specific worksheet w/in a workbook in excel. Is there a way to do this? Thanks so much!

I think all you need to do is something like this:

"C:\\My Documents\\MyExcelFile.xls#MySheet!A1"

If your sheet name contains a space, then you need to enclose it in single quote marks, like this:

"C:\\My Documents\\MyExcelFile.xls#'My Sheet'!A1"

Best,
Dan

Relevancy 57.19%

Here is a challenge for all you Excel Gurus Attached is a macro that when you run it searches for the file that you have selected in an Excel worksheet For example I have a file called testing cells I have typed this file in Cell A I then select cell A and run the macro and voila the Excel file called testing cells appears The reason I do not Excel Hyperlink Macro do a normal Excel hyperlink is that the hyperlink at times does not work if I e-mail it my Excel Hyperlink Macro colleagues since the file is on a Excel Hyperlink Macro server This is due to how the paths are configured in different computers The attached macro works great if I m hyperlinking to another Excel workbook I have tried to customize the macro to bring up a pdf file but without success I m Excel macro guru As a matter of fact the attached macro was given to me by John Walkenback the author of many Excel books Is it possible to do this or not I do not want to waste anybody s time if this is not do able Mario nbsp

I guess no one out there can help me on this issue. Surely to God someone must have a clue.

Mario

Relevancy 57.19%

Hi Guys,

I havecreated an Excel spreadsheet. I have hyperlinked various cells to other foldersbut I’m getting a warning (See Below) appearing when I click inside the cellwhich has been hyperlinked, the warning says that the folder I am linking to isan “unsafe location do you want to continue Y/N “. I click yes and the location opens.

Can anyonetell me what I’m doing wrong here or how can I disable the warning box?

Regards

Relevancy 57.19%

Im looking to remove Recently used e-mail addresses: in the Insert Hyperlink.

So you insert a hyperlink. Down at the bottom left hand corner left click on E-mail Address.

Were it says Recently used E-mail addresses:

Then gives a list of addresses used.

How do i delete email addresses i dont want in there?

It only leaves me the option to click and not remove.

I'm not familar with specific problelm but 'recently' used email addresses is possibly a cashe from outlook. .nk2 files in these folders. Not sure if you can edit but you can delete and it will rebuild.
&#9632;Windows XP
&#9632;Windows Vista and Windows 7

Relevancy 57.19%

I have created buttons with hyperlinks to other excel sheets in the same workbook, but I would like the sheets to appear with the selected cell being the last one which was edited/saved on that sheet.I can only find how to either go to a specific cell or, by omitting the "cell reference", cell A1.Any solution please?

I'm not sure Excel keeps track of the Last Cell Saved.and I know of know way to keep track of such information,especially if your talking multiple sheets.If the data is always entered as the last cell in a Row or Column, then there may be a solution. It _may_ also be possible with a MACRO, but I do not have the skillor knowledge to answer to that type of solution. MIKEhttp://www.skeptic.com/

Relevancy 57.19%

I have a user who has an off and on problem with a particular mapped drive and PowerPoint, Excel, and Word (all 97). The drive letter is R and it's where plenty of data is stored for multiple people to use (those who have rights). She'll use the File>>Open command and move to the R drive. Sometimes there is no problem. Other times the mouse cursor will turn into an hour glass and hang the machine.

I haven't had any luck finding anything on this type of problem. Any ideas? We're running NT Server 4 on all servers and Win98SE on all clients.

A:Word/PPoint/Excel file open prob w/mapped drive

This sounds to me like the integrity of the user's connection to that drive is the problem, and has nothing to do with the programs themselves.

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
http://www.brainbench.com

Relevancy 57.19%

Hi all,

Windows Server 2003 SP2 - is sharing a folder, and the client PC's that are opening files on LAN.

There are 5 PC's 3 with Windows XP, one uses Windows 7 and another one Windows Vista, the problem is detected only on the XP machines. When users try to open a Word or Excel file it hangs, other files are opened instantly (*.pdf, *.exe...). They use Microsoft Office 2007.

What could be the problem ? Why Office files are freezing when being opened from a shared map ?

P.S.: I removed the "Microsoft Office File Validation Add-in" still the issue persists.

A:Microsoft Word or Excel file hangs when being opened from a shared location

Try this: A computer that is running Windows 7 or Windows Server 2008 R2 takes four minutes to open a Microsoft Office 2003 document from a network share
Excel 2003 Slow Opening From Network Share | Welcome to Pariswells.com

http://www.techsupportforum.com/forums/f10/microsoft-word-or-excel-file-hangs-when-being-opened-from-a-shared-location-648051.html
Relevancy 57.19%

Hi all,
Windows Server 2003 SP2 - is sharing a folder, and the client PC's that are opening files on LAN (100Mbps).
There are 5 PC's 3 with Windows XP, one uses Windows 7 and another one Windows Vista, the problem is detected only on the XP machines. When users try to open a Word or Excel file it hangs, other files are opened instantly (*.pdf, *.exe...). They use Microsoft Office 2007.
What could be the problem ? Why Office files are freezing when being opened from a shared map ?
P.S.: I removed the "Microsoft Office File Validation Add-in" still the issue persists.

Relevancy 56.76%

I'm using an old version of Office 97, and I'm experiencing an odd variation on a problem I thought that I had solved, regarding how to modify the appearance of embedded hyperlinks.

Just recently, any inserted hyperlink in Word is now showing up looking like this, with this odd trailing subscript capital T after the standard underlined hyperlink itself:

Nothing I see in the Style formatting under Hyperlinks seems to account for or explain why that subscript T shows up. I can easily backspace it out of the hyperlink, but I wondered if anyone else has a suggested solution to this problem. Thanks!

CDobyns said:

I'm using an old version of Office 97, and I'm experiencing an odd variation on a problem I thought that I had solved, regarding how to modify the appearance of embedded hyperlinks.

Just recently, any inserted hyperlink in Word is now showing up looking like this, with this odd trailing subscript capital T after the standard underlined hyperlink itself:

Nothing I see in the Style formatting under Hyperlinks seems to account for or explain why that subscript T shows up. I can easily backspace it out of the hyperlink, but I wondered if anyone else has a suggested solution to this problem. Thanks!Click to expand...

It's very simple try using hyperlink or anchor tag
LoansDirect

Relevancy 56.76%

Exactly what the title says! How? Thanks.

A:How do I make a hyperlink of a word or sentence, etc.?

In what? Word, Excel, Outook, the forum editor?

Relevancy 56.76%

Does any one know why Word 2000 hyperlinking has a nice option to hyperlink a document by just clicking on the folder name(s) and then on the document itself. Outlook (both 2000 and 2002) makes you type in the the complete path and file name such as file\\my documents\helpme.doc. Users just can't do the file name thing. Can Outlook be changed so that hyperling is like word? I have attached a file if you want to see what I am talking about.

A:Hyperlink options different in word vs outlook

I don't think so, but consider this:

Browse to the file, right-click and hit properties.
Copy the name and path.

Relevancy 56.76%

Hi there,

I have a question about inserting a hyperlink into a word 2003/2007document. Is there any way to have a link insterted without the user having to press ctrl to click on the link? I have tried with the full path as the link and also using a a keyword pointing to a url but each time the user has to hit ctrl to open the link. Is there anyway a user can just click the link to go to a webpage?

Thank you.

A:Solved: Hyperlink in a word document

In MS word go to Tool\Options, select the Edit tab, and uncheck the "Use Ctrl+click to follow hyperlink" option.

Relevancy 56.76%

I have a word document that is littered with hyperlinks. The links themselves work fine, but for some reason, most of them are not blue anymore! All I'm really looking to do is try to find a way to use a macro or something to go through the document and add the "Hyperlink" style format to each hyperlink.

I tried to edit some macro code myself (one that changes all the links URLs), but I keep making the problem worse! I used to be good at VBScript, but it's been ages since then.

Any easy solution that doesn't involve manually changing each style?

As a side note, all of them currently are in "Normal" style, for some reason.

A:Trying to fix hyperlink problem in Word! Getting stumped!

It's also worth noting that the problem isn't that I've clicked links and it changed for that reason. They are mixed between black and blue. Most of the black links have a blue underline.

Relevancy 56.76%

Click ToolsOn the General tab, click the Web Options buttonIn the Web Options window, click the Files tab.Clear the check box for “Update links on save.”Click OK to save your preferences.

Relevancy 56.76%

I have many sites that I frequent that I have saved in a word document. I click on each one and it opens a new tab for each in firefox. My question is this. Is there anyway to open all links automatically or with a click, without having to click each one, that are located in a word document?

For example, the add on to firefox where you can draw a square around many links at once and they will all open. Hope this makes sense and thanks

Bookmark them and put into separate folder of bookmarks, then open all in Tabs.

Relevancy 56.76%

Running Excel 2003, I can't create a hyperlink because I am getting this error, "This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator". Since this is my personal computer what do I need to change to make my hyperlink work?

Thanks,

Upon further research, this is what I did to fix it. : See http://www.slipstick.com/problems/link_restrict.htm#reg2

Edit Registry, Part 2

Start, click Run, type Regedit in the Open box, and then click OK.
Browse to HKEY_CURRENT_USER\Software\Classes\.html
Right click the value for the .html key and select Modify...
Change the value from "ChromeHTML" to "htmlfile" (or from FireFoxHTML to htmlfile)

Relevancy 56.76%

Hello All,

I was wondering whether any of you can help me. I am using the following hyperlink in excel. When a user clicks on it it open up another excel spreadsheet, in a different area on a shared drive.

here is the link i am using

=HYPERLINK("W:\Licensing\Gambling Act 2005\REGISTERS GA2005\AWP Premises Licence.xls")

Now this work fine. However I was wondering whether or not it is possible to also direct it to a cell or row of cells. I am using Excel 2003. I have tried the actual hyperlink icon and this works until I come to saving the spreadsheet and I get an error to say it cannot save certain elements and when I go back in to it the link no longer works.

Relevancy 56.76%

Hi, I have got an Excel spreadsheet which has incident numbers in column A. For each of these incidents I need to put in hyperlinks which are very very similar. The first part of the hyperlink is the address to the database and the second part is the Incident number itself. I'm trying to create a macro which automates the process of putting in the hyperlink plus the incident number in. Can this be done?

Relevancy 56.76%

I clicked on a cell which has the text that I want to embed in and navigated to Insert tab > Hyperlink, then Browsed Pages, so I pasted the url into the text box there and clicked OK. As soon as I click the link, I got this message:

I'm the only user on this computer and I don't know what to do.

A:In Excel 2007, how do I enbed a hyperlink?

Welcome
For a test to help to determine the cause of the problem and as a potential temporary fix, try with the hidden administrator

Relevancy 56.76%

I need to add a Hyperlink from this formula =IF($D$3="","",VLOOKUP($D$3,Database!$A$2atabase!$Z$199,5,FALSE)). Everything I have tried I have not been able to get it to work. Please help!

Relevancy 56.76%

Relevancy 56.76%

I need help with Excel. I have been using Excel 97. I creat cost reports on jobs. When we have a vendor to pay that vendor and amount of invoice is typed into cell. In the past I have been scanning the invoice in jpg form and saving it to a zip disk. Then I insert hyperlink. Then when I click on that vendor and invoice a copy pops up. Well yesterday I started getting a error message and I can't get any of my hyperlinks to work on any of the worksheets. The error message is "An unexpected error has occurred".

Relevancy 56.76%

I am not sure how to go about this macro. I am trying to produce a hyperlink in a column (equipment info) but as it goes down a row change the hyperlink to reflect its file name that is found in a different column.

so the hyperlink location is "\\SNOGP01\poshare\PoShare\North Omaha System Files\10 Year Mechanical Plan, major plant equipment\1AC-1A Info & Name Plate.docx"

The next one down would need to change the "1AC-1A" to "1AC-1A-M"

Any help is much appreciated.

Relevancy 56.76%

Hello!

I am new to this site and to the world of macros. I am creating a form in Excel for my company and cannot find any info for creating a macro for hyperlinked info.

Background of my form:
It's a time off request form. My dad (who knows a lot of Excel and macros (but not this kind)) has helped me get to where I am at this point.

Currently I have a dropdown for employee names. Once a name is selected, it automatically fills in their manager and department number. I have a Reset Form button to clear info out and would like to create a Submit Form button that would send the form to the manager. Is something like this possible?

I'm guessing it would need to pull from my Tables sheet.

Help! I hope I made some sense.

P.S. I will attach a sample of what I have so far.

Relevancy 56.76%

Relevancy 56.76%

Hi there I am looking for a solution to a problem I am sure can be solved with excel although I am a reasonable novice vlookup Excel + - 2007 hyperlink when it comes to excel I have workbooks both Excel 2007 - hyperlink + vlookup of which have a column which contains a reference code Excel 2007 - hyperlink + vlookup in workbook column b is REF and in workbook sheet customers column a is REF What I would like to be able to Excel 2007 - hyperlink + vlookup do is click on a REF field and it link me to the corresponding data on the other workbook I realise this will require two things first of all a lookup to use the data from the code column in order to line up the records and then a hyperlink function to create a link This is what I have so far yet I am having no joy HYPERLINK VLOOKUP B workbook xlsx Customers A A FALSE the value returned isn t really the issue i don t think if I can get it to point at the field it doesn t matter what is list ed there as long as I can click it My apologies if I am making no sense here like I have said my experience with excel is very limited Many thanks in advance for your help Column represents name nbsp

Relevancy 56.76%

I am using Acrobat 9 and want to set a hyperlink from Excel to a specific page in a PDF. I have tried destinations and links with no success. Any one able to do it. It is on a shared network drive and not a website.

A:Hyperlink from Excel to specific page in PDF

Did you create the pdf file? (do you have the originating .doc?) In some cases, yes.

Does the pdf have existing bookmarks? No, bookmarks

Relevancy 56.76%

Hi Every one This is my first time working with a tech Support Here is what is going on I have worked hard on creating a spredsheet layout for our church and used hyperlink to conect pages Everything was working great work 7 Hyperlink Office Excel want and then I added a ext backup hard drive and now my Excel Hyperlinks don t work Here is what I see when click on a hyperlink This operation has been canceled due to restrictions in affect Office Excel 7 Hyperlink want work on this computer It is not just in my spredsheet but also when I try to go to any help links I have tried other work sheets that I have made and they wont work ether Can you help me Newlife Tech Support Guy System Info Utility version OS Version Microsoft Windows Office Excel 7 Hyperlink want work Home Premium bit Processor Intel R Core TM i CPU M GHz Intel Family Model Stepping Processor Count RAM Mb Graphics Card Intel R HD Graphics Mb Hard Drives C Total - MB Free - MB D Total - MB Free - MB I Total - MB Free - MB Motherboard PEGATRON CORPORATION E Antivirus Norton Internet Security Updated and Enabled nbsp

A:Office Excel 7 Hyperlink want work

Hi wellcome to the forum.
Have you adde the external Harddisk as trusted so macro's are enabled?
This could be the reason

Relevancy 56.76%

I'd like to be able to click on a cell in Excel97 and rather than going to a URL or location in a file, I want to open a folder so I can see what files are in it. Is this possible? If so, how?
Mahalo
Kaneohe

A:Creating a hyperlink to a folder from Excel

In Excel, with the cell selected you want the link to appear in, go to Insert>Hyperlink, enter the text you want displayed in the top field and the path to the folder in the "Type the file or web page name" field. It has to be exact, no typos. For example, I just tried it with C:\Documents and Settings\AllUsers\My Documents\Miscellaneous and when I clicked on the link it made, it opened that folder.

Being the lazy sort, I just opened that target folder in Windows Explorer first and copied the path from the address bar, then pasted it in. That method also avoids typos.

Relevancy 56.76%

Trying to make a spread sheet with some weblinks. Some links are very short and will fit on the page, others run off the page onto another one. Is there any secret to shortening the link. It's even too long for landscape

Relevancy 56.76%

Hi All,

I am trying to create a hyperlink in Excel that will open up a specific page from a .pdf file stored on a network drive. Unfortunately I am only able to get the pdf file to open to the first page. Any help would be greatly appreciated!!!!

Thanks!

Relevancy 56.76%

i would like some assistance with inserting a hyperlink within an excel document. Within this same spreadsheet there are a number of both word and excel docs. These links all work. The pdf ones don't and comes up with the message NO PROGRAM IS REGISTERED TO OPEN THIS FILE. If I go to the folder it is stored in it opens fine. help would be appreciated.

A:inserting a hyperlink within an excel document

What program are you using to make this "PDF" file?

Relevancy 56.76%

I have a spreadsheet in Excel 2007 to which I want to create a hyperlink to an external website, which contains a special calculator, I will need to make reference. The link has been placed in a cell of the spreadsheet and would appear activated, as blue, but clicking on cell does not open the website.

A:Excel creating hyperlink to a website

Relevancy 56.76%

So I havea pdf (hundreds of pages) that is stored online for my company and I am trying to create a hyperlink in excel to take people a page 15 in the document. I've tried adding #page=15 and when I click the link it still takes me to first page in the document (as a result of url losing the #page=15). When I copy and past the link into the browser it obviously retains the page callout and work correctly.

Any thoughts or solutions would be greatly appreciated!

Relevancy 56.76%

I can't get a hyperlink I put in an Excel worksheet to open a Publisher file. If I point the hyperlink to another types of files (e.g., Excel, or Word, or jpg file) it works fine. But if I try to point the link to a Publisher file I get the message that "...some files contain viruses ... blah blah... Do you want to open the file?" I click OK then get the error message "Publisher cannot find the file you specified. The next dialog box will let you browse to locate the file....." Then I locate the file, click OK, and it opens. Same path and filename. I've pointed Publisher files all over my computer with the same results.

Any ideas???
Don

Ok. I made a test pub file.

I get the same message you do, but it then opens right up.

Are your publisher files associated with the correct Publisher program?

Do you know how to set a file association? I would double-check it just to be sure.

Meanwhile, never hurts to clean up your PC in case some temp file is getting in the way: www.theofficeexperts.com/cleanyourpc.htm and then maybe try running detect and repair on Excel.

If that doesn't work, try troubleshooting Excel at www.theofficeexperts.com/excel.htm

Let us know, Don.

Relevancy 56.76%

Hi all,
Using Excel 2010 and Acrobat X.

I have a spreadsheet with a list of names in one column and email addresses in another column. I want to combine them so that the name is displayed and the email address is a hyperlink. I can do this easily by using =hyperlink("mailto:"&a1,b1). The problem is that I then need to convert the document to PDF. The conversion will keep manual links, but not links created with the hyperlink function. I've seen a couple of suggestions such as saving the spreadsheet to HTML and then converting to PDF or a rather ingenious solution to copy the contents of the worksheet and then use Acrobat X to create a PDF from the clipboard. Both of those work, but they lose things like the borders around the cells and the repeating rows at the top of each page.

Any ideas? Thanks.

A:Solved: Excel Hyperlink Function to PDF

This should be the links as per Microsoft will create.
Not sure if this is what you are looking for.

Relevancy 56.76%

Computer: Intel 1.7 GHz, 1 GMB RAM, 2 40GB drives in RAID, Windows 2000 Pro. My profiles [all] are set at administrator level.

Suddenly [today], macros and hyperlinks have changed.

Macro setting has reverted to high in Excel, I get a message that I must adjust settings or used signed macros.

Hyperlinks do not work – at all – in Excel. The message: “Operation cancelled due to restrictions in effect on this computer.”

What happened; what needs to be done?

For the macro seetings, see if this helps, go to

Tools/Options/Security Tab/Macro Security, tick medium

Relevancy 56.76%

Not sure if this is possible but I d like to get a macro for the following I ve got a workbook with multiple tabs let s call them quot Summary quot quot Tab quot quot macro hyperlink Excel question Tab quot etc On the summary tab I d have a value with a reference next to it that says quot Tab quot I d like that reference to be hyperlinked to a similar cell on worksheet quot Tab quot where it finds Excel hyperlink macro question the reference that says quot Summary quot So basically if my summary sheet shows an amount of I d have a reference next to it that says which sheet shows the support for that number and on the supporting sheet it would reference that that amount shows up on the summary I d like to run a macro that would find those references and hyperlink them to the correct sheets and if it can do it to the specific cell on Excel hyperlink macro question that sheet Anyone Excel hyperlink macro question nbsp

Hi there, and welcome to the board!

Can you define your requirements a little bit more? We need to know about your data structure of your workbook. What ranges are you talking about? Are there any other hyperlinks? What would you like them to say? Care to give a real-world example with your file? Can you upload it?

Relevancy 56.76%

I have Excel 2007. Today, (never previously), when I click on a hyperlink to send an email to the subject, I get a Microsoft Office Excel message "This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator".

To my knowledge I have done nothing to create this. The only remedial action I have tried is a reboot, but the problem persists.

Can anyone offer any solutions please?

Relevancy 56.76%

I use an Excel document with hyperlinks to pdf files. When I click on the hyperlinks I get this message "The operation has been canceled due to restrictions in effect on this computer." What could be causing this and is there any way to fix it?

Thank you.