Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Hyperlinks do not work on local machine. I have a folder with pictures and another folder with Excell spreadsheet in which I have hyperlinks defined to the pictures in the pictures folder. I am using Office 2003. I am experiencing a very strange behaviour: a) I can open my Excell file from two other computers on my network and when I click on hyperlink the pictures they display O.K. I can also add new hyperlinks pointing to th... 8 19.06.2006 22:11:40 Linked workbook data suddenly not found Using Excel 97, Win 98/2000/XP. We have a number of linked workbooks that reside on a win 2K server. To the best of my knowledge, they seemed to work fine until Monday. Now suddenly, everytime one of the calling workbooks is opened and links updated, we get the File Not Found boxes. I have set the Default Path to the server location (\\dp\dp_c\hhcfiles), but the linking process seems to i... 3 07.06.2006 03:09:20 Excel limitation on number of hyperlinks in worksheet? Hello, I am attempting to run an Excel macro that creates thousands of hyperlinks to other sheets within the same file. On one of my larger sheets the macro always crashes after a few minutes with VBA runtime error '1004' "Application-defined or object-defined error". Is there a hyperlink limitation in Excel? I couldn't find any such limitation documented anywhere. Thanks! ... 1 12.07.2006 19:30:45 linking data in excel and access I am trying to look up a reference value in a excel worksheet cell in an access database to display, in excel, a value related to that reference. i.e. enter a part number in a excel cell (reference). I want it to lookup that part number in an access database query and to display the location of the part in a cell on the excel worksheet ... 3 12.07.2006 16:41:02 Excel/ Outlook embedding or link Hello folks. I need to link or embed the value of a single cell in excel into an html email in an outlook public folder. The value of the cell contents will change weekly and the email will need to reflect this. I'm not using word as an email editor. - is it possible ? Thanks in advance forgot to add - using office2000 sp3 fully patched ... 3 12.07.2006 13:20:02 Centering on image when link is clicked Hello, I have a simple workbook that consists of two worksheets, first with data and second with maps relating to that data. I have links throughout the first sheet that take the user to the second sheet, my problem being that these sometimes display with the linked cell near the bottom of the screen (causing a totally different map to be displayed in the center). Are there any ways to mak... 2 10.07.2006 08:05:01 Problems saving a worksheet with links Does anyone know how I can resolve this issue ... I have a directory which contains 129 worksheets which have links to external data (in a Master Spreadsheet) -- I need to copy these files into a New Directory, but kee the Master Spreadsheet (which they are linked to) in the original location. If I do a simple Cut & Past, the Reference Link to the Master Spreadsheet gets moved to the New Di... 2 08.07.2006 23:25:27 Simplifying my Previous Request for Assistance I suspect that (since I didn't get any response on my previous request for assistance) I may need to approach this in stages ... Assuming that Information Rights Management (IRM) won't give me the detailed permissions I need, basically, here's what I need: 1. A Macro that will unprotect a series of Workbooks (approximately 200 of them) so that the Auto Update function in Linked Data c... 2 06.07.2006 13:07:42 Simplifying my previous Request for Assistance I suspect that (since I didn't get any response on my previous request for assistance) I may need to approach this in stages ... Assuming that Information Rights Management (IRM) won't give me the detailed permissions I need, basically, here's what I need: 1. A Macro that will unprotect a series of Workbooks (approximately 200 of them) so that the Auto Update function in Linked Data c... 1 05.07.2006 22:11:18 Updating Linked data in Excel Does anyone know the best approach for this? I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional spreadsheets which have ODBC links to various rate tables in an ACCESS database. Here's the scenario: Part 1. In ACCESS, I have a various Rate Tables where I maintain and update corresponding rates for various programs. As these rates are changed in ACCESS, the correspond... 1 05.07.2006 20:01:53 Linking and embedding question. Hello, Here is a scenario. I have a folder which I am going to use various forms from we will call this the template folder. I have an excel file called information.xls I have a word file called work.doc I will use the two files over and over again and create new new directories in which to put them. I will change information in the spread sheet r1:c1 What I want to do is create a l... 7 04.07.2006 17:05:33 Excel file with hyperlinks takes a long time to open over the network Hi All, I have an Excel (Excel 2000 SP3) file (2 Mbytes) with about one thousand hyperlinks to word document or excel document. This Excel file is situated on a machine on our network. - When I open this Excel file from this machine : it takes about 5 minutes - When I copy this file from this machine to my PC : it takes about 15 seconds - When I open this Excel file from my PC : it tak... 4 04.07.2006 15:39:10 Formula Link References Change to Startup Directory Haven't been able to find info on this problem anywhere. Formulas in my spreadsheets that link to other spreadsheets are, unbidden, changing to reference the startup directory (c:\Documents and Settings\username\Application Data\ Microsoft\Excel\XLSTART) INSTEAD of the shared network drive where the files ACTUALLY reside. The startup directory path is being substituted in for the portion of t... 4 03.07.2006 13:19:18 Startup Prompt to update Links Hello, Excel 10 SP3, WIN XP Prof. 5.1 SP1 When I go to "Edit" => "Links" => "Startup Pompt" I can select "Don't display the alert and update links". But the alert is always displayed when I start a file with such a configuration. Does anyone know, what' s the use of this option? Regards Werner ... 3 03.07.2006 06:49:11 Creating a Hyperlink from a Single Word Can I create a hyperlink in Excel from a single word or do I have to link the entire cell in Excel 2003? Thanks, Kara ... 2 01.07.2006 11:40:58 pasting "links" into Word Documents Hi there I have a client who has say, 14 forms, containing fields, some of which have the same data. I have bookmarked these fields (which I probably don't have to do) in the Word document and created an Excel spreadsheet which contains the data. I then copy and Paste Special (as a link) to the Word document. This works fine, except if I sent both these documents to my client and he trie... 1 30.06.2006 06:39:53 Querying Info inside excel I want to query information within my excel workbook. This information has been queried externally then a couple of calculated columns have been added that include logic that MS query doesn't support. I then want to query this info. I have tried formulas to pull from these cells but as my query expands or shrinks I keep getting ref# on the formulas where the cells no longer exist. My solution... 3 29.06.2006 22:19:34 Dead links retreiving data? Hi, I have a cell linked to a file that no longer exists. After this file was deleted, I expected to see "#REF" in the cell. (I always update links when opening files.) However, the cell contained the data from the last time the link was valid. Any idea why a link to a file that doesn't exist is bring back data? Thx. ... 2 26.06.2006 21:08:43 Linking Excel to Powerpoint across the net? Many times I've object linked an Excel file to a Powerpoint presentation. Using a third party add-on, you can then cause the Powerpoint file to update every time it cycles through. Would it be possible to reach out across the net to a text file saved on a server somewhere to get your info? That way, you could update your ongoing Powerpoint file from anywhere. Thanks! ... 2 21.06.2006 22:40:21 Condidtional formatting question Can someone help me please? I use a flowchart that shows numbers either in black (meets minimum standards) or red (does not meet minimum standards). Because I have formulas in every cell through the second week of September, the cells for future weeks show 0.00%. Can someone suggest a way to format the cells for future weeks to show as white text so the numbers are not visible? I don't wa... 2 19.06.2006 20:50:15 Hyperlinks to Powerpoint doc Hi There, I've never noticed this before but when i create a hyperlink in an excel spreadsheet and insert a link to a powerpoint document on my network, when i click on the link it brings up the powerpoint document in a slideshow even though the document is just a normal .ppt and not a .pps. Is this the way that excel handles links to powerpoint or is there a way to turn this off? ... 1 14.06.2006 11:09:02 How do I get around the 255 char limit? I am linking a master spreadsheet to numerous spreadsheets. I am pulling in text back to the master spreadsheet. I know that excel has a 255 character limit for linked cells. I noticed however that when I initially establish the link I can pull in 700+ characters. I have realized that you get all the characters when the source spreadsheet is open. In my case opening that many large spreadshe... 4 13.06.2006 12:25:06 Broken ODBC Connection I am not sure if this is the correct location for this question but here it goes. I have a user with several spreadsheets that update data from an odbc connection. The odbc connections are pointing to ASG Safari InfoServer (not that that matters, just an FYI). I upgraded the application, and the user can log in and connect to InfoServer, but all the odbc connections in her spreadshe... 2 12.06.2006 22:47:36 Links in 2003 I ahve a spreadsheet, when I open it in Excel 2000 and click do not update the sheet is fine. But when I do the same thing in Excell 2003 all the figures are replaced with #Value. Is there a setting I need to change so that the sheet will open in 2003 just as it does in 2000. -- Regards Clair... 3 03.06.2006 10:26:26 Hyperlinks break when synching from Pocket Excel I'm using a very simple Excel spreadsheet as a checkbook, and have taken to linking entries for cleared checks to their images, obtained from my bank, which I keep in a folder adjacent to the one the spreadsheet's located in. I keep a copy of the spreadsheet and the images, in the same file structure, on my Axim handheld and synchronize the files with MS ActiveSynch. I find, however, when I... 1 01.06.2006 14:32:18 9 Pages: 1  2  3  4  5  6  7  8  9