|
|
Help - external data by
I have a problem with external data. In the Data Range
Properties, under
Data Layout.
There are 3 options after
'If the number of rows in the data range...
|
April 11th, 2005 08:52 PM
by
|
0 |
119 |
|
|
Excel 0 and Blank fields. by
I am working on a spreadsheet that is relatively simple, but I need to have
empty cells and cells input with a 0 to give a referenced cell different
values. I...
|
|
2 |
87 |
|
|
Macro to delete a group of CELLS by
I am trying to get a macro to delete a group of cells as I parse down
through the block of instrument data, to weed out blanks or corrupt data. I
just want...
|
May 8th, 2006 04:29 PM
by
|
4 |
194 |
|
|
|
|
2 |
120 |
|
|
Updating Linked Data in Excel by
Does anyone know the best approach for this?
I have (roughly) 200 EXCEL files that have VLOOKUPs to 5 additional
spreadsheets which have ODBC links to various...
|
July 5th, 2006 09:02 PM
by
|
0 |
91 |
|
|
|
July 6th, 2006 02:01 PM
by
|
2 |
78 |
|
|
Running Macros by
I have the following Macro (which I need to run on approximately 200
different workbooks) -- what is the BEST way to achieve this? Should I use
a Function...
|
|
1 |
85 |
|
|
Problems saving a worksheet with links by
Does anyone know how I can resolve this issue ... I have a directory which
contains 129 worksheets which have links to external data (in a Master
Spreadsheet)...
|
|
1 |
83 |
|
|
|
July 12th, 2006 10:08 PM
by
|
0 |
108 |
|
|
Excel 0 and Blank fields. by
I am working on a spreadsheet that is relatively simple, but I need to have
empty cells and cells input with a 0 to give a referenced cell different
values. I...
|
March 8th, 2006 04:29 PM
by coatej
|
2 |
82 |
|
|
|
|
3 |
122 |
|
|
|
|
2 |
93 |
|
|
|
|
1 |
82 |
|
|
|
June 8th, 2005 03:27 PM
by sal
|
2 |
105 |
|
|
|
January 1st, 2006 05:57 PM
by
|
2 |
194 |
|
|
|
January 5th, 2006 12:51 AM
by
|
0 |
62 |
|
|
|
January 5th, 2006 12:51 AM
by
|
0 |
91 |
|
|
|
January 6th, 2006 02:43 AM
by
|
0 |
107 |
|
|
Rounding Question by
Does anyone know if the format function ("Format/Number with x number of
decimal places) happens to conform with ASTM E29 for the last...
|
|
4 |
87 |
|
|
Missing Password in DSN File by
Hi,
I've recently upgraded from Excel 97 to Excel 2003 and am now having a
few teething problems with my old DSN files. It seems that Excel 2003
no longer...
|
January 6th, 2007 03:37 PM
by
|
3 |
82 |