Dear All Happy new year
I had creat pivote table on table that was exported from Access (it was
exported from query that based on relation beteen tabled ) ,if i make
refreshing data on the same filds the new data will be refrexhed withot

Don't know how to slant the borders in a column. Don't want the line that
runs through the middle. Want the side borders to angle at 60 degrees if
possible. Know it can be done just not sure how.

Good Morning All,
Using Excel and Windows XP.
I want to record a macro and place it in the Personal Macro Workbook.   When
I click ok I get an error message "Personal macro workbook in the startup

How to hide grids in a selected group of cells?
I want to keep grids in the rest of the sheet.

Does Excel offer a way to alert you of a change in data?
I am responsible for the tracking and maintenance of our fleet of vehicles.
I would like to know if there is ANY way to set-up a spreadsheet so that
every 3 months or 3,000 miles, Excel will let me know that the vehicle is

How do I get a number to be displayed in say 2 significant figures, all
that I find in numbers formating is decimal places.
Thanks.

Hi there, I'm trying to do a countif function on  calendar cells.
I have sheets named "Jan" thru "Dec" and the range is "D6" thru M35"
I can't seem to get this function to work!
I've a few different ways including naming the range.

I am inporting external data (market securities data) from website. The
"external data range properties" has a tab to auto-update the data in
minutes. But I want to update the data in seconds (may be two or three
seconds once). Please advise me, how do I do this?

1. Enter the following formula into a worksheet cell :-
2. = QUOTIENT (36,16) + RQP
3. Where RQP (=26) is a Named Formula (well defined).
4. The given formula appears to calculate well until the partial

Hi!  Thank you for taking the time to read this.
I run an internet retail business.  We advertise on search engine
large and small.
I have to make a decision on whether or not one of our smaller ad site

I am hoping someone can help me with my problem.  Recently my Excel
starting acting funny.  When in page break view I cannot move the page
break with my cursor.  Also, when I am wanting to edit the range of
cells in a formula.  I normally click on the first cell referenced in

I am building a quoter tool for a client who does masonry work.  The
part that he hates the most is writing scope paragraphs on his quotes,
i.e. the scope of the project that he is quoting (ex: Remove remaining
old sheetrock and old tile.  Install new tub and shower valves in same

Is there a function opposite of "CONCATENATE"? I have a list of names
with the first and last names in the same cell. Doesn't do well if you
want to sort by last name. I diregress, rather than re-typing the whole
list I would like to know if anyone knows how to split the string at a

I have a problem with my VBA code when I try to read values from cells
in two different worksheets. When I run the macro the program tells me
that I´m out of bound. But everything works when I save the data in
the same worksheet. How shold I write the code so that this simple

J10:N40 may contain data pertaing to 5 activities on each of the days of the
month. I need some help to detemine the total number of day's registered
activities have taken place. Tks