Hi, why when I use vlookup on cells that have a formula in does vlookup return me 0.00 values...

I have a spreadsheet which is linked to an Access DB table. In MS Query, I changed the drive mapping (eg G:\data\etc) to the server name (eg...

Hello, I'm using Excel 2002 and have a spreadsheet in which nearly every cell has somehow come to contain an unwanted hyperlink to an external file. I...

I have some excel sheets that are linked together and the location of the file server changed. Now when one sheet is opened it updates fine but other sheets...

I have a number of worksheets within one workbook that is broken down as follows: worksheet 1 (JAN 05) has ten columns of unique monthly data and ten columns...

hi, my next question is : I want to vlookup a value in a range say : j1:d500 i.e. 0020091 is the lookup value

Hi Nick, I need to read the data in DB2 table on Mianframe ( Z/OS) and create the report on excel. According to you I may have ODBC connectivity. Can you...

Hi I need to read the data in DB2 table on Mianframe ( Z/OS) and create the report on excel. I came to know that using ODBC connectivity we can get the data...

Hi, I need to transfer one mainframe file to PC in excel format. This needs to be done automatically like FTP with out manual intervension. We create report...

I have a massive file which contains many sheets and i have one summary sheet with a column of hyperlinks which reference each sheet separately. Since i...

Try this site: http://TheGoodStuff.cc

Hi, I'm working on an Access 2000 database where I will have a spreadsheet on a network drive. i need people from other groups to update the spreadsheet, but...

I have Windows XP and Excel 2002 SP3, I have go into EditLinksStartup Prompt and selected the radio button for Don't display the alert and update links. ...

Hi there, I have a spreadsheet that someone spent a lot of time on, in getting data presented exactly how they wanted it. A report I have from Crystal...

I have a list of hyperlinks that are stored in fields(Range A1 through A200, for example). I would like to print them(essentially send it to Acrobat Distiller...

Hello, I'm using windows xp and am trying to link 2 worksheets using the following example: Sheet 1, block 1A equals Sheet 2 , Block 1A using this command...

I have created a worksheet in Excel 03. I am trying to link a large number of the cells to another worksheet in the same workbook. When I use Paste Link to...

I am new to this so bear with me, please. My first sheet of the workbook is my master which contains 9 columns -- 2 columns have a formula to calculate % of...

I have an access database. In this database, I have several forms and reports that need to be sent via email to other individuals. They need to enter info...

We have an application in Excel where we need to generate random user ids in chinese. We are able to do it in using numbers...