What am I doing incorrectly that is making it so that I do not even have the
"refresh data" option available to me in my pivot table?  I want to modify
the spreadsheet so that my pivot table and graph automatically update if I
change information in the mother formula worksheet.

I am trying to concatenate a number and preserve its formatting, but
the concatenate formuula insists on presenting the unformatted version
of the number.  Is there a way to enforce the format?  Formatting the
cell where the concatenate function runs doesn't work. I have tried a

I have the same formula twice in the same spreadsheet and am getting two
different results, even copied and pasted and made sure the cell references
aligned, happend over and over again with this formula.
Here are both versions:

i have a formula like this:
column               m
row 4               =text(h4,"yymmdd")&" "&g4
row 8                 copy formula

My brother has three separate customer lists by state and would like to keep
them that way but he would like to combine them in one file.  I moved all of
the lists to one file and placed each state in its own tab.  I now have a
combined tab and can copy and paste them into one ...

is there a function that takes data entered in a cell in worksheet a
automatically enter in a cell in worksheet b ??????????

I have several cells on a worksheet that "magically" create a formula when I
enter data into the cell.  I've deleted the contents of the cell, assigned a
variety of formats, etc, to no avail.  But, if I copy the contents of another
cell and paste it into these cells things work ...

I am attempting to concatenate two columns and put the result into a 3rd
empty column.  I keyed into cell C3 =A3&B3 and hit enter.  All that shows in
Cell C3 is A3&B3 as a text value.  If I click on the = sign to edit the
formula, the result of the concatenation shows just fine ...

I have different size files that have data on every other row.  I need to
locate the last row that has data in it. I would like to start at the top
(B1) of column B and be able to use a shortcut or macro to immeadiately go to
the last cell that has data in column B.  any ideas?

I am trying to sum up 3 cells of 2,140.22. (Net pay)
Yet my =sum(M9:M11) delivers the number 6,420.67. That is an incorrect
amount for my payroll records. ??

I have a report template that uses getpivotdata from pivot tables hidden in
the background.  There are many templates in use and refreshing each one was
becoming very time consuming.  I hoped to use one central set of pivot tables
and point all of the indivual reports to this ...

Basically i have a UDF in a module that is just
public function whatCellAMI() as string
   WhatCellAMI = "Row: " & RowFunction & " Column: " & ColumnFunction
end function

I have several spreadsheets which I use for data gathering (usually in
columns, but could be in rows) and where I need to do calculations
based on the last (ie most recent, at the bottom) entry in the column.
Although Excel has functions designed to help me find the largest,

How do I enter same formula in the same cell on multiple sheets?

I've copied a list of English suffixes ("-able", "-ation") etc. into a row
of my Excel worksheet.
However, because the web-page table I copied them from has prefixed(!) each
suffix with the equals sign, I'm getting the error #NAME? in each cell. When