Excel add-ins #3
Does anyone know how to get the data-analysis add-in for excel 2001?
Do I have to upgrade to 2004? I had a very difficult time trying to
marrakech75 <email@example.com> wrote:
> Does anyone know how to get the data-analysis add-in for excel 2001?
> Do I have to upgrade to 2004? I had a very difficult time trying to
The add-in is on the install CD
...EXCEL:printing row headings at the top of every page.
I have looked at the EXCEL help and am not able to get row
headings at the top of every page. I see the sheet tab
and I see where I am "supposed" to enter the rows to be
printed at the top of every page. HOWEVER these cells
are "grayed out" i.e. inaccessible. Is there something
else I need to do before I can access this function? It
seems simple enough, but I am not able to enter rows to be
Are the sheets grouped? as this will cause that to happen, in which case you
need to ungroup and set the print area.
Ken.............Inserting rows into sheet that contains a formula
I have a typical financial sheet where the columns sum (sum(a5:a15)) and the
rows sum (sum(a5:h5)). The summation columns are locked and the sheet
Is there a technique whereby I can have the user insert a row which will
keep the formats and row sum as well as changing the formula in the column
The following method is not foolproof but generally it works OK.
Insert a blank row between the bottom of data to be summed and the row with
the sum formulas.
Include the blank row in the sum formula.
Protect the blank row along with the formulas and what...I clicked "clear offline items" in Calendar. Can I restore?
I accidentally clicked "Clear offline items" in the Calendar properties, now
all my calendar is blank. How can I restore?
it should repopulate itself within a few minutes. What type of email account
do you have?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
Poll: What ver...Configuring the way an excel file opens.....
I have a workbook which contains 9-10 sheets. First sheet
is the Main sheet which contains the information about the
workbook and sheets therein.
Whenever I open the workbook I want the Main / First sheet
to appear on the screen always.
How can this be done?
Thanks in advance
...Convert a word address and data list to excell
I help with a food pantry and the existing cliant data list was created in
word seperated by commas. I am told to put all 1500 or so cliants in to note
pad, then put them on one line (data of each cliant seporated by 7 commas and
their children seporated by ;) then I can put them into excell. Well I am
only up to the C's and have been doing it for 3 weeks now. Plus we keep
adding new ones every week which are not in order now.
If anyone could help me with this I would so appreciate it.
if they're still in Word, select the list and choose edit / replace
in...clip art inserted into business card prints solid black box
I have entered clip art into a business card, it shows up fine on "Print
Preview" but when it actually prints, it is a solid black box.
What format is the image? High-resolution pictures can cause this especially if
they are a 48 bit tiff. Import the clipart into an editing program and change
the image resolution.
Mary Sauer MSFT MVP
"Mendy" <Mendy@discussions.microsoft.com> wrote in message
news:54608BE3-54BC-4D0...scientific notation to display 1.8 x 10-5 in Excel
Can Excel display scientiic notation as, say 3.00 x 10-12 as opposed to the
How about a helper cell:
=SUBSTITUTE(TEXT(A1,"0.00E+00"),"E"," x 10")
And you can use the original cell for calculations.
> Can Excel display scientiic notation as, say 3.00 x 10-12 as opposed to the
> number 3.00E-12?
...VBA: Insert Page Breaks code is not working in Excel 2010
I have a snippet of VBA code to insert page breaks after a particular row.
This works fine in Excel 2007, but it doesn't in another Excel 2010 machine.
It doesn't seem right to me that VBA code would behave differently in
different versions of Excel. Am I missing something??
RE: Am I missing something??
Yes, your code.
"iswarya" <u59539@uwe> wrote in message news:a6e77011b51d5@uwe...
>I have a snippet of VBA code to insert page breaks after a particular row.
> This works fine in Excel 2007, but it doesn...Macro that inserts lines
I have this macro that inserts a line if the value in D changes and copy the
value in D to A. I want this macro to only start looking in D14 or from row
tx for all the help
Dim row_index As Long
Application.ScreenUpdating = False
lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row
For row_index = lastrow - 1 To 2 Step -1
If Cells(row_index, "D").Value <> _
Cells(row_index + 1, "D").Value Then
Cells(row_index + 1, "D").EntireRow.Insert _
Cells(row_index + 1, 1).Value = Cells(row_index + ...Help with Excel 2007 Interface programming
I need to do 2 things...
1) Capture data input into a cell prior to hitting Enter.
2) Create a box under the cursor (like when you start typing a formula into
a cell and Excel displays the resulting possibilities).
If you can opoint me in the right direction, I can figure it out from there.
Sounds like you are after a WorkSheet_Change event for the first question?
This will fire after data was entered but can tell you what was entered.
For the second question, depending what you want to show, you may be able to
use a Data Validation input message or a popup menu. But...Inserting a Flash Animation on an email
How can insert a flash animation to an email. Where
does .swf file has to be so the person that receive the
email can see the animation?
...Changing Text to Time in Excel
I have a large database that is sent to me for anaysis on a regular basis.
My problem is with times. They are sent to me in the for 0122 as text. I
need help converting them to a time that excel can deal with (without
manually fixing them, as there's about 100,000 pieces of data that need to be
Thanks your your help.
add a helper column
and copy down
"Chip193" <Chip193@discussions.microsoft.com> wrote in message
> I have a large databa...CListCtrl slowing down after several insert's/delete's
Here's a twist on a classic question on CListCtrl being slow to remove
thousands of records. I'll first described the setup then the various
tests I did. The program is running on Win98, I guess on XP I won't even
know if there's a difference, but I am curious about why it gets slower
after multiple fill in a listctrl.
I have an executable acting as the main program. Menu option calls a
dialog box (call it DIALOG A) in a DLL which displays ~250 records. This
listctrl loads in a flash. Upon selecting a record from the list,
another window (call it DIALOG B) is di...Can I stop rounding in excel?
I am doing come calculations and end up with 139.7 for example. If I format
the cell as a number with no decmial points it automatically rounds up to
140. Normally this is ok, but in this case I don't wnat it to round. Can I
turn the rounding feature off?
> I am doing come calculations and end up with 139.7 for example. If I format
> the cell as a number with no decmial points it automatically rounds up to
> 140. Normally this is ok, but in this case I don't wnat it to round. Can I
> turn the rounding feature off?
If you format the cell as "gener...cross linking excel files
ok, there is a nut that i cant break.
I have 2-3 excel files that need to be linked.
File M (master) contains multiple worksheets, of all sorts of data, its
the master file for my files
File L, is a lookup file im creating for better usage, its used for
dumping data from msproject and reformat some stuff. It has only one
sheet of relevance.
File S, the summary file is the thing i need help with, it is linked to
both files and is used to create monthly summarys. In that file i am
using a lot SUMIF elements like:
SUMIF ([file M]sheet1!A1:A30;B8;[file M]sheet1!D1:D30)
Now the thing is: Th...how do i superscript part of a cell in MS Excel? #2
When I use the superscript option after selecting just a portion of the cell,
the superscript appears during edit mode only. How do I get it so it appears
as superscript on the spreadsheet or when printing? Again, I'm only trying
to superscript part of a cell's contents, not the entire cell.
Did you hit enter have you applied the format change?
And you can't do this kind of formatting to formulas or real numbers.
It has to be text.
If you do this a lot...
John Walkenbach has a helpful addin that you may like:
>...setting of screen zoom in excel
I need to have the Pre Set Zoom sizes of 85% and 65% in replacement of the
75% and 50% Excel Zoom Out Defaults.
Is it Possible? Thanks
I do not believe you can change the defaults in the Zoom dialog but you could
assign macros to buttons.
ActiveWindow.Zoom = 65
Or a on button toggle-switch to go forth and back.
If ActiveWindow.Zoom = 65 Then
ActiveWindow.Zoom = 85
Else: ActiveWindow.Zoom = 65
Gord Dibben Excel MVP
End Subntoro <Sunantoro@discussions.microsoft.com> wrote:
>I need to have the Pre Set Zoom sizes ...using the MOD funktion in excel 2003
11:00:00 PM (A3)
3:00:00 AM (B3)
i am trying to use mod to work out the number of hours that a person
worked using excel
so i used the following formula =mod(B3-A3,1) i keep getting the
following error #Name?
thanks in advance for any help i can get
=mod() shouldn't cause an error.
My first guess...
If you look at the column headers, do you see A, B, C, ...
or do you see 1, 2, 3, ...
If you see numbers, try changing this:
tools|Options|General Tab|uncheck R1C1 reference style
And reenter the formula.
Or maybe =mod() is called a different n...Excel Function #2
I need to find a way to look for and specific value whithin a range but with
the following characteristics:
Product Country Segment Jan-04 Feb-04 Mar-04
Bankcards Argentina Total 425451 422546 419999
Bankcards Chile Total 87096 86881 86339
Bankcards Colombia Total 116440 116133 116545
Bankcards D R Total 5267 5384 5499
Diners Argentina Total 3198 2863 1513
Diners Chile Total 176 165 235
Diners Colombia Total 1959 1145 1250
Diners D R Total 293 316 514
I would like to find for any given month (variable) the total for Bankcards
and Diners for every country. I try to use the lookup function b...Insert File (Insert as Text) Into Contacts
I'm using O2003. I have a number of files I always insert into my
contact's notes. By default, the Insert button on the "Insert File"
dialog defaults to inserting the file. Is there a way to change this
button to default to "Insert as text"
srm <firstname.lastname@example.org> wrote:
> I'm using O2003. I have a number of files I always insert into my
> contact's notes. By default, the Insert button on the "Insert File"
> dialog defaults to inserting the file. Is there a way to change this
> button to default to "Inse...Exporting Excel data to Oracle DB
I am looking for a way to take information from an Excel spreadsheet and move
it into an Oracle database. My first question is, can this be done? And
second, what are the limitiations?
I would greatly appreciate any info.
...How can I hide a column in excel?
How can I hide a column in Excel that others I send the sheet or workbook to
cannot unhide, but can still add/modify other information in a sheet or
You can lock the cells in that column
(select the column|format|cells|protection tab|checked Locked)
Unlock the other cells
Hide that column
protect the sheet (tools|protection|protect sheet)
But xl's worksheet protection isn't made for this. It can be broken really
quickly. If you have stuff that others shouldn't see, don't put it in a
workbook that you share with others.
> How can I hide ...Excel will not allow me to use the funtion MROUND,
Excel will not allow me to use the funtion MROUND, any
I am using the expression =MROUND(10, 3)
if you receive a #NAME error you have to activate the Analysis Toolpak
Add-in. Goto 'Tools - addins' and check this Addin (you may be asked to
insert your installation CD)
Paul D wrote:
> Excel will not allow me to use the funtion MROUND, any
> I am using the expression =MROUND(10, 3)
The Analysis Toolpack needs to installed.
Tools>Addins> Analysis Toolpack.
Paul D wrote:
> Exc...Unable to insert record in table
Using SQL Server 2005.
I have a table with one required field (key field, var type int) and various
other optional fields.
Yesterday, my Access VBA code failed to action the following SQL statement:
INSERT INTO ORDERS (OrderID) VALUES (9121165)
I got a time out error and a report that the record could not be inserted
(error code -2147217887).
So I opened SQL Server Managment studio and opened the table. When I tried to
insert a new record using the same OrderId, I first got a timeout error and
could not add the record. AFter OK'ing the error, I was able to cli...