At our office we have people using both Excel 2007 and Excel 2003. Is there a
functionality in either (or both) of them to hide rows (or columns) that have
ZERO (not blank) values in an OLAP Pivot table without having to write
macros. It would simplify most of the reports, but so ...

Through macro, how do I name a range which consists of blank cells in
between.  The range will be derived dynamically, where only the starting cell
is known. For example, Range starts frm A5, and end cell should be selected
dynamically based on the data. In between the dynamic ...

hi community
when I hide a column say, Col B, and gave a Protection Sheet command, the
protection worked accordingly with the "Unhide" column command dimmed but
when I do a selection on the whole worksheet and paste it to another

I have an Excel application which I need to export to a TXT file for
import into another system.  The column lengths are fixed i.e. Column
A = 10, Column B = 30.  In total there are 800 characters per row.
I wanted to use VBA to export the file by clicking a button using the

I am using Windows XP -I have excel file where Sheet 1 has 500 rows &
15 columns of data
and similarly Sheet 2.
Excel is saved in the extenstion *.xls, Excel 2007 has new

I need to create a spreadsheet that looks like a meta-layer tree.  The first
column will be departments, and then should expand to include the people in
that department.  I need to be able to keep the departments in order and the
people in order within each department with ...

I found the following code at http://www.mcgimpsey.com/excel/timestamp.html 
quite useful.
The only question is that how to make it work if a series is entered if a
collection/range is changed?

If there is a number, say 123456, in cell A1, is there a formula I can write
that will put a decimal point between the 4 and the 5, making the number
1234.56?

Iget the following error message
"Run Time error 1004
Unable to get the legendentries property of the legend class"
 This occurs when users enter invalid parameters for a query that fetches

I have two sheets namely price_sheet and order_sheet, I have a price
database made with dynamic range which has the following headings on
"price_sheet"
   A             B               C                D

I'm trying to locate a formula where I can make my work easy.
The questions is: I've 15 sheets(1 sheet for each employee) in a workbook,
where we store the data of alloted work and in them we got 12 variety of
issues. So what I'm trying to do is - count/Sum the action and the date ...

the Excel Column Header is in number(1,2,3) instead of letters (A,B,C). How
can I change it?

Could anybody tell me if it is possible to report row results based on the
last data entry in a column. Here is the example: -
Say if I have the version number in column B.
A        B    C    D    E

I have a slight problem with excel.  I downloaded a timetable template,
however instead of putting times in the cells I want to put peoples names.  
Everytime I try and type in a cell it asks for time format 12:00am.  How can
I change this so I can type in text

Hi there. I have a simple piece of code that was written in Excel 2007, but
saved in 97-2003 Excel format. This code seems to work fine in both Excel
2007 and 2003, but not in Excel 2000. He gets a 1004 error message when he is
clicking on the drop-down box. When debugging, the ...