Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   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 11/22/2005 8:29:43 AM 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 11/19/2005 2:30:25 PM 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 11/18/2005 9:29:11 AM 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 11/16/2005 7:43:22 PM 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 11/16/2005 12:25:59 AM 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 11/16/2005 12:25:58 AM 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 11/16/2005 12:25:57 AM How to delete all defined names from a workbook? Hello How to delete all defined names from a workbook? ... 16 11/14/2005 3:26:17 PM 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 11/14/2005 5:20:02 AM 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 11/8/2005 4:32:04 AM excelhulp www.excelhelp.tk voor uw problemen met excel ... 2 11/8/2005 1:46:39 AM 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 11/8/2005 1:27:19 AM 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 11/3/2005 1:49:46 PM 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 11/3/2005 9:47:31 AM Updating worksheets from another file I have a pricing book that was created in Excel with a menu page. I have added some columns to allow me to put quantity, margin, extended price, etc to this price book. Every month, my company releases a new price book, however, periodically there are new products on it. How can I have Excel automatically copy the new menu page along with the new corresponding pricing to my original b... 1 11/2/2005 6:10:05 PM Excel links I want to make sure that if I send out a spreadsheet with a linked spreadsheet, that the people I send this to will not be able to open or display the linked infomation. Does excel make sure that this infomation cannot be displayed? ... 4 10/26/2005 7:21:06 PM 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13