I am trying to find out where this command is on Office 2007. Can some
one help.
L Krishna Kumar

I would like to change some colours in my Pivot charts and other
things such as how heavy a line is and also to be able to mix charts
i.e change it to line and bar chart but every time I look back at my
sheet the chart has reverted.  Anyway that I can change this as saving

I am inputting data in sheet 1 col A to G
I want that same info to "PRINT THRU" to Sheets 2 and 3. Can you tell me how?
Thanks

I would like to write a macro with vlookup function in vba. Without a
macro (and vba) I do something like that
colA, colB
23, =vlookup(A1, myRange, 2, 0)

I have a spreadsheet and I am trying to run a macro on all sheets.
Here is my code for the first sheet called U.S.
Sub whatColor()
   For counter = 5 To 15

I have a spreadsheet in Excel 2003 format which has some data and
charts in it. The data is obtained using links to various other
workbooks. I am able to see all data in 2003 format, however in excel
2007 format, i am not able to see the data. Is there some problem in

I deployed office service pack 3 to all 900+ machines at work and found out
that this security update renders all wk4 files blocked. I need to find a fix
for this due to my company using a AS400 system and Lotus notes. This file
type is needed to export data from the AS400 so it ...

I have a date in a cell (constant, not the result of a formula).
Is there any keyboard shortcut that will add 1 to the date, or do I
need to write a little macro?
Example: cell contains 2007-12-14; pressing the key combination

A friend who does not have internet access has asked me to pose this
question for him.   Somehow he has managed to plant a very nice calendar
(similar to the one you get when you click the time in the system tray)
smack in the middle of his spreadsheet.   He cannot remember how ...

I've been having a problem with an Excel sheet that calculates time.  Very
simply:
Column A: I have a sprinters lap time (for example 00:02:43 - formatted to
[hh]:mm:ss - so the runner did the lap in 2 minutes 43 seconds)

I have a single column list that is 700+ rows long.
Individual items within the list can appear several times in the list.
I want to convert this to a list where each item only appears once with the
sum of the number of times it occurred in the original list in an adjacent

I know I have asked a similar question.  
However, is it possible to get a formula to look at a cell that contains the
month and then use the number of days from the previous month?
Thanks in anticipation

I initially developed some UDF's in an XLS, which was used for testing.  All
was fine.  An XLA was then created with these UDF's.  In a new XLS, these
UDF's also work fine.
But in the original XLS used for development I removed the UDF's from the

When I run the "transfer from AS400" I get to the final process where its
pulling the data into excel, excel crashes with a fatal error.
Any help....

I created some VBA code that pops up a little date picker calendar
whenever specific cells become activated. Problem is that when people
are moving around in the spreadsheet with the arrow keys and they hit
one of these cells the calendar pops up and stops them.