Compile error in hidden module
Wed, 19 May 2010 05:28:30 -0400
When I try to load a particular add-in(*) I get "Compile error in
hidden module". I've checked the usual suspects, but I can't find the
cause. I have of course left a message for the author, but after
three days with no reply I expect I won't get one. Suggestions?
Here's my setup:
* Windows XP, Excel 2 ...
|
Pivot table, calculating % difference of subtotal rows
Tue, 18 May 2010 14:31:51 -0700 (PDT)
This is what I need to do: I have rows of data in a pivot table that
have subtotals associated with them (automatically generated via the
pivot table). I need to to take the subtotals for 2009 and 2010 and
calculate the % difference.
Here's a screenshot of what I'm talking about:
http://home.comcast.net/~w ...
|
Extracting Phone Numbers
Tue, 18 May 2010 14:20:53 -0600
I have many lines of data in which each includes a telephone number. The
lines are not consistent in text or spacing. The number can have either a
(403) area code or a (587) area code.
I want to extract the number and have tried the following, which results in
a #VALUE!
=IF(MID(A2,(FIND("(587)",A2)),14)= ...
|
Automatic Carriage Return
Tue, 18 May 2010 07:01:02 -0700
Is there any way to have Excel automatically do a carriage return in A:A
after 4 digits are entered? I want to key in 4 digits in A1 and have it
automatically go to A2, then enter my next 4 digits in A2 and automatically
go to A3....all the way down column A.
--
Mike ...
|
SLOPE function malfunctioning
Tue, 18 May 2010 00:48:01 -0700
Dear All - I hope someone can offer advice.
I am using Windows vista and Microsoft Office 2003 â?? professional edition â??
I bought the computer in Dublin, Ireland, with Vista installed in June 2008
and the Office software before that.
I am having a serious problem with excel. For my research, which I am ...
|
50 Category=AgXLB_WorkbookFile Error
Mon, 17 May 2010 23:03:54 -0700 (PDT)
hi all,
I am using an Excel add-in product from Infor (FMS Sunsystems)
Management called Vision XL version 10 and I have been getting this
error from my Excel 2003.
?SethiddenSheetIndex Error 1004 Add method of Sheets class failed 50
Category=AgXLB_WorkbookFile?
This error is not critical and I can click ...
|
MS Stock Quotes
Mon, 17 May 2010 17:56:04 -0700 (PDT)
I have been using MS Stock Quotes add-in for several years now.
Recently I wrote and installed a macro to simplify some tasks that
includes getting a quote. The add-in appears to interfere with the
operation of MS Stock quotes.
I was wondering if anyone has experienced this problem before and how
to solve it. ...
|
|
|
referencing filtered data
Tue, 18 May 2010 00:45:50 +0100
I have filtered a large table according to the values in the first column
and I now want to refer to that filtered value in a formula at the bottom of
the filtered data.
If the filtered value is 2 I want to use 2 in a formula, and if I then
filter on the value 3, I want the same formula to then pick up the ...
|
Excel Puzzle: Tracking Change in Hours
Mon, 17 May 2010 17:04:12 -0700 (PDT)
We export a spreadsheet with the following information:
StudentID, LastName, FirstName, Enrolled Hours
2700, Smith, Bob, 3
19243, Hancock, John, 5
533, Doe, Jane, 7
Every day or two, we would like to export an update of the same
spreadsheet and see if the hours have changed for the student from the
last t ...
|
Date that does not update
Mon, 17 May 2010 13:35:01 -0700
I am trying to use the =NOW() or =Today() formulas to track changes to a
sheet. When A1 is not blank, I need B1 to display the current date and time
(and repeat down B:B). The problem is I can't have the formula update once
the date is there. It would be too much work in this situation to use
ctrl+shift+; ...
|