Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Links broken - UNC vs drive mapping Hi all, I have discovered a difference of behaviour which I would be interested in hearing others' views on... we have a master spreadsheet which contains links to other workbooks, some in the same location (or subfolders of) x: and some in a different location altogether, y:. All is fine as long as the master is not moved... if it is moved, the links to workbooks in the same area break,... 6 16.12.2005 09:52:59 Finding and killing all Access queries in an Excel spreadsheet I've just switched from one Access application to another as the data source for an Excel spreadsheet, as a result I'm having to swt up all the links all over. Inserting the new links isn't a problem, but I can't seem to get rid of all the old ones. Although I'm pretty sure I've gotten rid of all the references to the old database I still get error messages about the path (to the old data... 2 13.12.2005 03:01:02 Link Updates I am using Excel 2002. I have 9 workbooks which have extensive linking. Eight of the workbooks auto update the links when they are opened by themselves. One workbook, however, gives me the warning that some links cannot be updated when it is opened by itself. Also, I do not get the warning when the other two linked workbooks are opened at the same time I open this workbook. Now, the ... 2 10.12.2005 00:04:55 Re-establishing Links When I open an certain Excel 2003 file with links, I am prompted to update the links that are in the workbook. Once "Update" is clicked, another dialog box with the option to "Continue" or "Edit Links?" opens. If "Continue" is selected, the file opens without updating, and if "Edit Links" is selected, I'm taken to where I have to re-establish links. The problem is that no files have b... 1 08.12.2005 21:01:02 How to open a spreadsheet on a named sheet from a hyperlink? Hi, Can anyone help me with this? I have looked all through Excel help and the only hyperlink info concerns inserting them into a cell. I have a spread sheet that has numerous named sheets within it. Opening the spreadsheet from a hyperlink on a webpage always opens it on sheet # 1. Is there any way of opening the spreadsheet on a named tab, lets say for example I have 3 sheets, Req... 2 03.12.2005 03:55:43 can excel view drill throughs in a pivot table I'm building pivot tables in Excel 2000 based on data cubes from SQL 2000 Analysis Services. Is there anyway to view the drill down from the data fields in a Excel pivot table? I try doubleclicking in a data field cell and get a message saying that I can only get detail from rows or columns. -- ************************************************* Andy S. MCSE NT/2000, MCDBA SQL 7/2... 2 01.12.2005 21:53:28 LINK EXCEL INVOICE TO A SPREADSHEET Hi It is a long time since I have used excel and need help I want to use an invoice and the data to be inserted into a spreadsheet at the same time. Must be my age cannot remember how it works. Any help would be gratefully received. Old Dodger Sue ... 3 01.12.2005 07:39:42 How to keep cell font setting after inserting hyperlink Hi, I have a problem with my MS Excel 2002 (actually it exists in MS Excel 97 too). Every time I'd associated a hyperlink with the text inside a cell, the font will get change e.g. from Arial (size 10) to Arial (size 7). How can I instruct Excel to keep the original font setting without change ? :) ... 9 28.11.2005 23:12:21 Convert links to result I am looking for a way to convert linked cells to their actual (fixed) values in a workbook which is password protected except for the cells I use for linking. Would need macro which would find all non-protected cells and do something like copy>paste>values. Thanks... 2 28.11.2005 17:15:53 Hyperlink Problem Hi I have posted this question in the Excel area but have not recieved any replies, maybe someone here can help. I run Win200 with Excel 2000. I have a spreadsheet that is protected. Some of the cells are not locked so that information can be entered into them. When I copy a hyperlink from an external program and paste it into the unprotected cell it works fine. The problem I have is... 2 25.11.2005 23:46:23 Obtaining a single Access record from Excel input The standard "Import External Data" function in Excel makes it easy enough to obtain a single record in Excel from an Access database, but I'm trying to figure out how to use a figure in the spreadsheet in the MS Query. For instance, if I want to put a person's name in a cell and I want a particular person, I can easily get this with the Query Wizard, PersonID "equals" and then pull down t... 6 23.11.2005 09:02:36 Recalculating Links I need to use Find and Replace (Excel 2002) to modify a lot of formulas. Is there a way in VBA to disable the recalculation of each cell after the formula is updated? It's taking forever! I tried the follwoing but it does not work: Sub Macro1() Application.Calculation = xlManualCalculation Application.ScreenUpdating = False Application.AskToUpdateLinks = False Cells.Replace Wha... 2 22.11.2005 08:29:43 Linking table in Excel to word Is there a reasonably simple way to link a range of cells in Excel to a table in Word such that the word table is not messed up by adding a line above the cell range in Excel? If I've linked a 5 x 3 table of, say B5:F8 to word, adding a row above the table in the Excel document will result in the Word version losing its bottom row and picking up a new one at the top. So it will still be l... 2 19.11.2005 14:30:25 comparing two rows, then highting? I use excel to make up lists of keywords. I enter a different word (or several words) to the first cell only in each row, but as there can be hundreds of rows, I'm looking for a quick way to identify (back ground colour perhaps) rows with matching words (after doing an alphabetical sort, so matching rows are together) so I can delete the duplicates. Can I reiterate... One column of word... 3 18.11.2005 09:29:11 Nieuwe excelsite om uw gebruikersvragen voor te leggen aan andere gebruikers Beste lezer, Per vandaag zijn we met een site begonnen waar u gebruikersvragen over excel kunt voorleggen aan andere gebruikers. U kunt uw vraag op het forum stellen, het grote voordeel ten opzichte van deze nieuwsgroep is dat u ook (excel-)bijlagen kunt toevoegen (max. 200 KB). In de toekomst zal de site uitgebreid worden met diverse links/boeken/tips e.d. De site is reeds te vinden... 1 16.11.2005 19:43:22 Averaging Value between Two Serial Dates Hi all, I have two spreadsheets. The first spreadsheet contains two columns, one for start date/time (in serial format) and the second for stop date/time (in serial format). The second spreadsheet contains two columns. One containing a serial date/time and the other containing a meteorological value (eg. temperature). I want Excel to read the start and stop date/time from the first spr... 2 16.11.2005 00:25:59 When Breaking Link Excel Crashes HI, I have recently discovered a problem with my copy of excel When I try and break a link from one spread sheet to another my copy of excel crashes and then recovers the data. I have tried reinstalling windows office xp but this problem is still continuing. It's excel 2002 Any help would be greatly appriciated.... 2 16.11.2005 00:25:58 Averaging Values Embraced In an Interval Between Two Dates Hi all, My spreadsheet contains a matrix of data in four columns by approximately 600 rows. The data is structured as follows: column A = start date column B = start time column c = stop date column d = stop time Each one of the 600 hundred rows contains a different set of start/stop information. I have another spreadsheet which lists meteorological information over this same tim... 2 16.11.2005 00:25:57 How to delete all defined names from a workbook? Hello How to delete all defined names from a workbook? ... 16 14.11.2005 15:26:17 no blanks Can someone please help me to make this formula =SUMA(SI(S!D4:D1000=S!G4:G1000,1,0)) not to count blanks i need to count nubers that are the same in the same row Example: D4 G4 300.00 300.00 Count like one Thanks in Advance ... 2 14.11.2005 05:20:02 Excel 2003 cell contents truncated when linked into Word? I have a worksheet with cells that contain about 200-3000 characters. These cells are linked into a Word 2003 document using the {LINK Excel.Sheet8 C:\\filename.xls SheetName!namedcell \a \r \f 4} syntax. Problem is that my cells are getting truncated at nine hundred-something characters or so. This does not seem exactly consistent (I cut pasted text into new Word docs and one was 990... 1 08.11.2005 04:32:04 excelhulp www.excelhelp.tk voor uw problemen met excel ... 2 08.11.2005 01:46:39 Save Link Problem Hi I run Windows 2000 & Excell 2000 with service pack 3. I have an autoshape button that I have added a hyperlink to which opens a html file on a server. When I add the hyperlink and press the autoshape it takes me to the file ok. I can do this as many times as I like and it works ok. The problem arises after I save the spreadsheet. As soon as I save the spreadsheet the hyperlink ... 2 08.11.2005 01:27:19 Reflecting info between an excel file and a word one or two excel file. I have an Excel file that I use as a database with the dates of the time when my company does the maintenance of our electronics tools (we work in an industry that uses them a lot, we have around 200 in an Excel file). So the documents look as follows (the images are copied and edited in paint, that's why they look kinda weird). They are next to each other; I divided it here in order to fi... 1 03.11.2005 13:49:46 Prompt to update links Hello, I'm using Excel XP SP3 and WIN XP SP1 Descriptiion: Settings in "Options - Edit - Ask to update automatic links" is "Ask to update automatic links" checked. Settings in "Edit - Links - Startup Prompt" is - Let users choose to display links - Don't display the alert and update links In both cases Excel prompts me to update the links. What's the sense of the second option? I... 1 03.11.2005 09:47:31 9 Pages: 1  2  3  4  5  6  7  8  9