|
|
vlookup returns 0.00 by
steve alcock
Hi,
why when I use vlookup on cells that have a formula in
does vlookup return me 0.00 values...
|
|
4 |
281 |
|
|
External Links not working by
alexkr
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...
|
|
1 |
244 |
|
|
Hyperlinks to Files, Make Them Go Away by
Joe Reggae
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...
|
|
3 |
221 |
|
|
Link errors by
Bad Beagle
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...
|
|
1 |
220 |
|
|
Enabling Formulas Between Two Worksheets by
boyertown_casket
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...
|
|
1 |
186 |
|
|
vlookup ranges by
steve alcock
hi,
my next question is :
I want to vlookup a value in a range say :
j1:d500
i.e. 0020091 is the lookup value
|
May 3rd, 2005 02:57 PM
by JulieD
|
3 |
214 |
|
|
How to transfer a mainframe file to excel by
sesh
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...
|
May 2nd, 2005 08:19 PM
by DB2
|
2 |
234 |
|
|
Creating excel report from DB2 table by
sesh
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...
|
April 25th, 2005 10:07 PM
by sesh
|
0 |
212 |
|
|
How to transfer a mainframe file to excel by
sesh
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...
|
|
1 |
177 |
|
|
Activating a Hyperlink W/O using the mouse by
swatsley
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...
|
|
4 |
230 |
|
|
|
April 19th, 2005 05:15 AM
by Andy
|
0 |
178 |
|
|
Excel -> Access -> Excel by
ChrisBat
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...
|
|
1 |
121 |
|
|
Why still asked for Link Updates? by
Steven M. Britton
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. ...
|
|
5 |
229 |
|
|
vba macro required ? by
Peter O'Leary
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...
|
|
1 |
138 |
|
|
Printing Hyperlinks stored in fields by
TheGuru69
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...
|
|
0 |
129 |
|
|
Blank Links in Worksheets by
Roberta Fischer
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...
|
April 12th, 2005 03:45 PM
by JulieD
|
1 |
141 |
|
|
Paste Link by
akpud
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...
|
April 12th, 2005 12:09 AM
by akpud
|
4 |
189 |
|
|
Linking with multiple formulas by
jwr
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...
|
|
2 |
187 |
|
|
Importing access database info into excel by
jwr
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...
|
|
2 |
449 |
|
|
numbers in chinese by
Deeps
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...
|
April 11th, 2005 02:51 AM
by Deeps
|
0 |
264 |