Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Due Date it is possible to see in excel sheet for excample. 10/10/2007 15/11/2007 28/09/2007 30/04/2008 06/12/2007 18/08/2009 the above dates i want to see befor due for 30 days to change difference colour or any other, it is possible please help me Best Regards Anshad... 3 11/2/2008 6:06:01 AM Excel 2007 not showing "previous data" I have a lot of Excel 2003 spreadsheets that I cannot change from a thirdparty. When I opened them in Excel 2003 as was able to not update the links and show the previous data. No matter what combination of settings I put in to Excel 2007 it is not showing me the previous data just #Name where the link would be. can anyone give me a pointer as to what I can do to resolve this. I get the ... 3 10/31/2008 10:16:02 AM nique Value Macro requested I need a macro to do the following: 1. I have a spreadsheet with 10 rows and 7 columns (70 cells totally). 2. These cells will be filled with values (X,Y,Z etc.). 3. I need to take the unique values alone from these cells and copy it to another sheet in the same workbook. I've been trying so many options (Data filter, formulas etc). Can any one please help me out... 3 10/31/2008 10:11:03 AM Paste Links not updating automatically Here are the specifics: - working with Excel 2003 - I'm linking cells between two different workbooks - cell in the source Workbook A contains a VBA formula to count cells of a specific color. Workbook A, sheet1, cell H95 paste linked into Workbook B, sheet1, cell D20 When I performed the paste link into Workbook B, sheet1, cell D20 the references to Workbook A was an absolute refer... 4 10/28/2008 11:52:36 PM workbook link failures My problem is two pronged; both may be connected as they happened at the same time. The first is that all of the Excel shortcuts on my desktop are no longer operable. This problem only relates to Excel. All other shortcuts are operable. The Excel shortcuts will open only the Excel header toolbars but not the workbook. I get the error message:- "Windows cannot find (the... 4 10/23/2008 8:32:33 AM Politics ess berkeleyism popularity fandoms curves bystanders notes kwertee pnch... 1 10/22/2008 10:01:32 AM Linking CSV file Hi I run W2K with Excel 2K. I have a workbook that links to a file on a server. The file on the server is a file that is downloaded from a mainframe in a CSV format. Also, although this file is a csv format it has been setup to download with a .XLS extension. For my workbook link to this file to work correctly, I have to open up the csv file and save it as an true Excel file. If I d... 8 6/28/2007 10:35:12 AM Emailing an Excel Workbook with Links Greetings, When emailing an excel workbook with links to other workbooks, the drive of the linked spreadsheet is being changed. For example, the attached spreadsheet would be linked to another spreadsheet in a shared drive, "M:...., but when the file is sent through outlook (email) it is changing the linked drive to "C:..... I am not sure what is causing this issue. Does anybody have a... 3 6/29/2007 2:54:12 PM Bring a total from one page to another. Hello, I have a work book with allot of pages and want the total amounts from the various pages to self add on a single page for quick viewing instead of going to that actual page and scrolling to the very bottom to see the total. The totals page has each department name and under that name I want the totals to be real time auto add on page 1 under that name. If I can get one example I w... 6 6/27/2007 3:22:21 AM Web Site Lookup Folks: I have a simple 1-column Excel spreadsheet containing the ticker symbols of a variety of stocks. Now, manually I can go to a website (http://www.briefing.com/Investor/Private/Calendars/EarningsCalendar.htm) & individually type in these ticker symbols then wait for the printed results to displayed on a new window. Then I would copy the data of interest to me (a single date - yy/yy... 5 6/27/2007 2:13:10 PM How to find if workbook is being linked to I need to make some changes to a Workbook A but don't know how many other workbooks link to it. I'd like to open the other workbooks before I make the changes Workbook A so the links don't get messed up. ... 2 6/29/2007 12:14:36 PM EXCEL TIMER CONTROL HI ALL, I NEED TO KNOW HOW TO DESIGN TIMER CONTRIL FOR EXCEL SHEET TO LOCK IT AFTER SOME TIME PERIOD PL.HELP THANKS AVINASH ... 1 6/28/2007 10:38:34 AM Avoid Update Links dialog in Excel 2003 I have a workbook with links, and I don't want to be asked whether I'd like to update these, as the Workbook_Open event will open them in any case. I've set the "Startup Prompt" for this workbook to the bottom (3rd) option, but I still get asked every time. Any idea why? ... 4 6/29/2007 12:11:28 PM en_files_–_Excel_2007 When I open a file with links to another file, a security warning shows in the message bar showing that automatic update of links has been disabled. When I go to the Trust Centre it shows that Prompt User on Automatic Update of Links is selected. Microsoft help seems to imply that if I don’t want to update, I should get a button Don’t Update. However this button does not appear. Nor ... 3 10/6/2008 6:22:01 PM lost Hypertext links defined in cells of an excel spreadsheet I've defined hypertext links defined in cells of an excel spreadsheet, that are pointing on documents stored in different folders. They work fine for a while... Under some circomstances on my PC and each time I send the spreadsheet and the folders the targets document are stored in, the hypertext links don't work anymore, with either on or the other following messages : "The address of t... 2 10/7/2008 9:06:40 PM Hyperlink selection generates error message I have an Excel spreadsheet with multiple tabs and hundreds of hyperlinks on each tab. Randomly, when a user selects one of these links, an error is generated; "Microsoft Excel is waiting for another application to complete an OLE action."... 3 10/18/2008 3:04:01 AM Manipulating ranges in a different file Hello, My excel file collects information from another excel file, where I have three columns: start_time, end_time, and another cell that is suppose to contain a name of the person. Within one range (3-250) I need to subtract end_time from start_time and see if it's less than 16 minutes, if so, if the third cell, does not contain the name, I need to count all the occurances and record the... 3 10/18/2008 3:01:01 AM VLOOKUP Not seeing all source links but find does Problem linking values from one wookbook / sheet to anouther. Almost all cells work fine but some do not, they do however if I copy/paste the lookup value into a "search all sheets" and double click the cell in the source sheet that contains the lookup value. Example: Look up cell for destination file on sheet1 = 1234 Look up cell from source file on sheet2 = 1234 ... 3 10/18/2008 2:45:00 AM CURSO DE INGLES HOLA SOY ESTUDIANTE DE LA UNIVERSIDAD TECNOLOGICA DE TLAXCALA Y ME GUSTARIA SABER¿EN DONDE PUEDO TOMAR UN CURSO DE INGLES PERO EN OTRO PAIS? ... 1 6/11/2007 7:37:24 AM Iserror does not work for missing sheets in linked file Hello, I have a file with links to another file. The formula I have tried is: IF(ISERROR(SUM('C:\Temp\mainfile.xls]sheet1'!$AT:$AT)),0,SUM('C:\Temp \otherfile.xls]sheet1'!$AT:$AT)) If sheet1 does not exist in the otherfile.xls, I get one of two events: 1. If otherfile.xls file is open I get the error message "Your formula contains an invalid external reference to a worksheet." 2. If o... 2 6/13/2007 5:31:56 PM Place source to drop down list in another spreadsheet What do I do when I wan't to use validation from a list, but I do not want the list to be visible on the spreadsheet? If I hide the rows containing the list, the hidden values also becomes hidden in the list. And If I link to a source list in another spreadsheet, I get an error. ... 3 6/16/2007 11:53:01 PM Changing formula links I have a master spreadsheet that calls on another spreadsheet(a) a completes the calculation, the problem is it is pointing at the wrong spreadsheet, spreadsheet(a). When I open up the correct spreadsheet, spreadsheet(b) and select the correct cell, I copy it then go the back to the master spreadsheet, select paste special and select 'paste link' this gives me the number from the correct s... 2 6/18/2007 11:29:00 PM Text Truncated after Paste link in Excel 2002 Hi, I have a excel file, which reads from many other excel files (created and updated by other users). I use Paste Links to read the data I need from the source files but due to 255 character limit the text string gets truncated after 255 characters. Does anyone know a workaround or solution for this? Please let me know. I am still using Excel 2002. Thanks in advance. Regards, Amol ... 2 6/24/2007 1:01:00 PM JPG files with HYPERLINK in 2007 When I open a JPG from Windows Explorer, it launches with Photo Gallery. If I hyperlink a JPG from Excel, e.g. =HYPERLINK("path\file.jpg","friendly name") it will open the JPG in Internet Explorer, which is not as useful. Is there a setting to make Excel launch JPG's with Photo Gallery (if it exists)? I am using Windows Vista.... 1 6/20/2007 3:43:02 PM Diabetic Recipes and More... Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Mr. Emeril Lagasse's fine recipes along with recipes for diabetic's. The website is full of great links from our partners. We have links to free cookbooks and more. Please stop by and support us. Visit all our links and choose the best recipe for you or your family. We look forward t... 1 6/24/2007 8:27:13 AM 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13