Very annoying behaviour of Excel 2003
Each time I am opening Excel, it is installing some component. This takes
several minutes, and becomes very annoying.
I recently had to reinstall XP and Office from the distribution CDs. I have
the problem since then. It certainly has something to do with the install.
Does anyone on this forum ever experienced such a behaviour.
I am running Office 2003 on XP SP3.
have you tried doing a repair in the help menu?
"Jean" <Jean@discussions.microsoft.com> wrote in message
news:020549D4-8070-46ED-8768-821EECD87C88@microsof...My hide sheet option in excel is not working
My hide sheet option in Excel is not working. It is grayed out so I can not
toggle nor use it to hide or unhide sheets. Security is at Medium - would
appreciate any insight into how to fix this.
Is the sheet protected? You cannot hide a protected sheet.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"arleen" <arleen @discussions.microsoft.com> wrote in message
> My hide sheet option in Excel is not working. It is grayed out
> so I can not
> toggle n...How do I get excel to accept (c) as text and not change to copyri.
How do I enter the text (c) in Excel without having it changed into the
Tools | Autocorrect | Select (c) | Delete | OK
"daffyd" <firstname.lastname@example.org> wrote in message
> How do I enter the text (c) in Excel without having it changed into the
> copyright symbol?
Go into the Tools Menu. Look for AutoCorrect. In the bottom half of the
AutoCorrect Tab, look at the list for Replace text as you type. Delete the
entry for (c).
"da...Setting series values on Excel Chart
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...Excel template that lists each month's meetings w/ some detail
I'm looking for an Excel template that lists every month of the year with
room to list weekly, monthly and quarterly meetings, including some detail
for each meeting. Probably would need to be landscape oriented. The main
intent is to give the person using it an idea of upcoming meetings, the
intent of each and what prep is required.
...How do I make a 'box and whisker plot' graph in Microsoft Excel?
I am in Year 12 and am doing a stats assignment. The project states that i
MUST insert a box and whisker plot for some data, but i don't know how to do
this. Does anybody know?
Here are some sites on the topic of stats charting not just box and whisker.
Andy Pope, Microsoft MVP - Excel
"Year 12 student who needs help" &...I've got a formula for stones and pounds
I've got a column that displays a series of weights in stones & pounds (both
in the one cell). How do I get a chart to recognise and display in the same
What is the format of the cells with stone & pounds
It is best to enter such values a 10 3/14 and format the cells with # ??/14
best wishes from one who is INT(275,14) stone & MOD(250,14) lbs
Bernard V Liengme
remove caps from email
"mikelenno" <email@example.com> wrote in message
The Implementation Guide refers to some planning files such as excel
spreadsheets and visio diagrams that are said to be found in the Planning
Tools folder. I cannot find any such folder. Anyone know where these files
can be found?
There is a download somewhere, called Planning_Files.exe, that creates the
planningtools folder and contents - probably/I think from
"Chris Hedlund" <firstname.lastname@example.org> wrote in message
> The Implementation Guide refers t...Cannot log in using WindowsID (was able to before)
I just bought MS Money 2007 Deluxe yesterday. The install went smooth,
without any issues. I registered a new WindowsID and was able to successfully
log into MS Money.
However, today when I tried to log into MS Money, the messge apeared that
the "Money was not able to recognize your WindowsID" or something like it and
that "You will still have access to some functions but will not be able to
make online updates".
Now I'm not able to make updates. Any idea what this could be? Is the
authentication server for WindowsID down or something?
See the post under Mon...Can't use Merge feature
If I have a postcard file I've already made on the
screen, when I try to pull up the "Merge" feature under
Tools, it is shaded grey and I can't open it. It insists
that I either form a new database list of addresses or
edit the one that I want to merge. I don't want to edit
the one I want to merge. I just want to MERGE it.
If, however, I have just a postcard template on the
screen (without it having been made into anything), I CAN
pull up the "merge" feature under Tools. It is not
How do I un-shade the "merge" feature?
To merg...Restore Exchange 5.5 on 2000 using ArcServe
- Windows NT 4 Server SP6
- Exchange 5.5 SP3
- ArcServeIT 6.61 with Exchange Agent
I'm trying to restore the Exchange information (database, mailbox...
everything) on another computer.
That computer has
- Windows 2000 Server SP4
- Exchange 2000
- Brighstore ArcServe 9 (build 2020) with Exchange Agent
Now the situation: I need to verify that the backup was made correctly
(entirely) in order to confirm the total validity of the backup (to validate
my disaster recovery plan) and to update to SP4.
I tried to find documentation with both Microsoft (for Ex...How to use structured reference (ListColumns) in VBA
I want to do something simple...loop through a range retrieving values one at
time and taking action on that value. This range is an Excel 2007 table
column. Easy enough...BUT I want to use structured references to a table
column by NAME, not numbers. I don't want to define new names, just use the
table column headings. I've found ways of doing it with quotes, but that's
not structured....the names in quotes do not change if the table heading is
changed by the user.
The formulas change if the table column heading is changed, but I want it to
change in VBA to...Default value of combo box based on another that uses DLookUp
I have a problem I'm trying to overcome regarding just one form which gets
its data from 1 table.
I'm trying to set the default value of a combo box to be the same as another
combo box on the same form.
The scenario is:
I have a form for entering info about financial planning Statements Of
Each client has a Plan Writer prepare their plan.
To find the plan writer that last prepared the plan for a client I have a
combo box with a DLookUp as its Control Source.
I'm usin...why do changes only save locally on networked excel file?
why do changes only save locally on networked excel file?
...Excel problem #3
I am attaching an excel file where i have a problem
In the file are 2 sheets, Main & second
I want to get data from second sheet to the main sheet by a formula by
which the amount in the total column will be posted in the second sheet
falling under various dates. I have done for 6 sept 2003 by way of
I do not know any formula by which i can do this automatically
Please help me
Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=444742
Message posted from http://www.ExcelForum.com/
one way: ...Save As using contents of Cell in Name
Can someone help with code that changes the "save As" file name to
combination of the original File Name + the contents of a cell, an
saves file in same folder as the original.
E.G. Original File Name= Timesheet
Cells B1= Location
Cell C1 = Date in format 3-5-2004
Cell A1 = concatenate(B1,C1)
Fle Name will therefore be "Timesheet Location 3-5-2004"
The other problem is with the date. When concatenating, how do I forma
the date to avoid it looking like "Location 38051"
Any help much appreciated
Message posted from http://www.ExcelForum.com
for c...Excel formulation to automate values
I have a little problem on arranging a small multi-worksheet excel here.
Let me explain in a short way then give some details on it.
I am trying to make an offers recordsheet which has two worksheets in it. One
for products(and their base prices) and an offer sheet. I would like to use
a bit dynamic data here. So when I type the name of the product excel would
give me the price from other worksheet.
Prices worksheet is something like:
1 Product BasePrice
2 mouse 5
3 keyboard 8
And the ...Removing hidden mailto:s from Excel?
I received a spreadsheet attachment yesterday and found a mailto:(my
address) embedded in a cell under a text string. It was evident in a
tooltip that appeared when cell was hovered-over. I told the sender
who now says that many of her spreadsheets - used to handle group
memberships - have such hidden addresses.
What terms would she use to search for these pests, either in My Docs
or on opening each sheet?
...Using Excel in Mac office 2004 with Microsoft/Mac 2008:Analysis toolpack
Although I am disappointed with Office 2008 for Mac because of the
Analysis toolpack, I figured things out quite recently that I can
install my Mac office 2004 and use the excel package that contains the
Analysis tool pack. How? ...... let me show you:
1. Insert your CD for Mac office 2004
2. When it open on your desk top, two options will be given to you to
download the software
(a) Office set-up assistant, and (b) Microsoft office 2004.
3. CHOOSE MICROSOFT OFFICE 2004 (Drag the icon onto your desk top) and
will start to run/download.
4. When done, this will appear as ...Printing Word and excel documents via excel vba
I have a document that has some Excel and some word content i would
like to use excel vba to print both a page from word and then a page
from excel. I know how to select and open the word document, however i
cant find any code to print page X from word.
basically i need to:
print page 1 of c:\xx\document1.doc
print page1 of sheet1 of c:\yy\excelwkbk1.xls
print page 2 of c:\xx\document1.doc
print page2 of sheet1 of c:\yy\excelwkbk1.xls
and so on it will require moving between word and excel - the excel
bit i get, but getting back to excel from word, and printing out in
word is slightly more...force excel to run in only one process excel.exe
force excel to run in only one process excel.exe, excel seems to want to
make multiple excel.exe loaded into memory which causes mysheet.copy to fail
so i have to close out the xls, kill all running excel.exe, then run the xls
again and the macro works. i only have to do this when i am actively
debugging a lot. if i just run my macro w/o opening the vba debugger, i can
run it as much as i want, but if i run with break points it crashes a lot
because of multiple excel.exe loaded into memory. perhaps there is a way i
can force excel to only load one excel.exe?
Are you using Automatio...Using Excel spreadsheet as input to Access
I posted this in the New Users forum but only got one answer, so
thought I'd try here as well.
Like so many others, I am an Excel newbie. I was a mainframe COBO
programmer in another life, but that was a few years back
My manager would like me to write an app that will take tracking dat
from an existing Excel spreadsheet (generated by our system) but onl
use a select handful of columns as input to a new Access database tha
I will create.
I'm guessing that I can either a) create a new edited spreadsheet to b
used as input to the Access database or b) use the Import wiza...Excel not displaying German characters correctly.
This is a real puzzler. Has our entire office and IT
We have two machines (M1 / M2) which are equal spec/
operating system, applications, versions, etc...
The only difference that we can see between the two
machines is that one (M1) has Internet Explorer encoding
set to "UTF-8" with "Automatic" selected.
The other (M2) has "Western European ISO" with no automatic
Now, when the machines log into a web application and
choose to download a German Excel file, M1 and M2 get the
file correctly if they have their encoding settings...MS Excel Paste Special>Paste All
Using MS Excel 2003
Paste Special> Paste All, doesnt quite paste the 'Column Widths'. Am I
always required to do the two step dance, Paste Special> Column Widths and
>>Am I always required to do the two step dance
"Excel User" <Excel User@discussions.microsoft.com> wrote in message
| Using MS Excel 2003
| Paste Special> Paste All, doesnt quite paste the 'Column Widths'. Am I
| always required to do the two step dance, Paste Special> ...Using Risk+ with MSP 2007
We use Risk+ as a risk simulation tool. We have discovered that it works
approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
into this problem. If so, is there a remedy?
My hunch this not a generic issue, but surely best that you consult with
the Risk+ people on this.
On 02/03/10 18:08, Tom Mc wrote:
> We use Risk+ as a risk simulation tool. We have discovered that it works
> approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
> into this problem. If so, is there a remedy?