|
... After I protected my worksheet, some cells can be changed...
I applied some protection i a worksheet and most of the cells work propoerly.
I can enter data where I want to, I'm restricted from entering data in some
cells, my formulas can't be changed except in two columns of cells.
I have two columns of cells that have a simple formula, =$N$2 ,
besides that the cells are formated for percentages. I can click into any of
the cells in these t...
|
4 |
25.02.2006 14:23:00 |
|
|
explorer doesn't activate excel files only starts excel programme
Hi, I have recently upgraded to MS Office Pro 2003, which is fine exept that
I cannot seem to access excel files from explore or my computer. All that
happens is I get the programme with a blank screen. I can get the file I want
by the usual file/open etc but this isn't much use for quick picks. Anybody
got any ideas about what I can do?
Regards
...
|
7 |
27.02.2006 17:26:49 |
|
|
PivotChart does not take individual diagram
Hello,
i set in Excel a new user-defined type of diagram to standard
now i make PivotChart under use my new standard diagram.
when i change the data (with the Pivot-DropDown menu) only
the old standard diagram is used. what wrong do we make?
thanks,
Oliver...
|
1 |
27.02.2006 13:10:29 |
|
|
Missing menu items
My Excel 2003 is missing the <List> submenu from the Data menu, even though
I have turned on the display of all menus. I noticed that the menu
displayed in the spot where the <List> should occur is a Mappoint 2004
integration menu. I tried removing the Mappoint COM add-in, but it did not
restore the menu. Anyone have any suggestions? I haven't tried
re-installing yet. If I do...
|
4 |
27.02.2006 07:58:27 |
|
|
How can I set up a subtraction function in Excel?
I am using Excel 2003, and I am trying to set up a subtraction function for
my income. Please give me some relevant advices. Thank you!...
|
2 |
27.02.2006 03:12:21 |
|
|
Real Estate - Free post Your ads about property for sale.
Real Estate - Free post Your ads about property for sale.
You can join for free and post your ads about property for sale or for rent.
www.World-Estate.com
...
|
1 |
26.02.2006 17:23:37 |
|
|
how do I "freeze" the left hand title column
I want the three left hand columns of my excel worksheet to remain fixed
while I scroll across the remaining 22 columns. How can I do this? ...
|
5 |
26.02.2006 12:21:03 |
|
|
Excel/Office Security
OS: XP Home Edition, SP2, with the latest updates.
Excel 2003, SP2, with the latest updates.
This one has been getting on my nerves and I am really hating it now. I
understand the purpose for it, but when I only use the application to open
my own files, it's rather quite annoying to have to go through the security
dialog box each and every time I go to open the file.
Security setting...
|
1 |
26.02.2006 04:41:48 |
|
|
Opening Excel and chosen file from Explorer
Windows XP Pro ... Office 2003
My issue is very similar to the "Gandalf" issue just posted. If I open
Excel directly from a menu, and then open the desired file using File/Open,
then all is well and functional. Excel works perfectly.
However, if I seek out and choose an Excel file using Explorer and attempt
to open that Excel file with a double click, then Excel opens, but the
back...
|
1 |
26.02.2006 02:52:27 |
|
|
Recent Files
Why Excell doesn´t keep the last recent files I opened?
It´s disabled in General Options tab (dimmed)....
|
2 |
25.02.2006 14:23:47 |
|
|
Problem with WIndows in Taskbar command
I have recently upgraded from Office 2000 to Office 2003. (I am running XP
Pro.)
When I open Excel, if I go to Tools>Options>View the box for Windows in
Taskbar is already checked. However, if I open multiple Excel files, they do
not show in the taskbar.
While the multiple files are open, if I uncheck Windows in Taskbar, and tell
it OK to close the dialogue box, nothing chang...
|
1 |
24.02.2006 23:37:27 |
|
|
Setting Shortcut Keys
Hello all,
Is there any way to specifically set shortcut keys to buttons
(programmatically or by tweaking the registry even)? I would like to
set Excel's "Format Painter"
and "Center" buttons to the same key combos as Word's (Ctrl + Shift +
C) and (Ctrl + E).
Unfortunately, Excel isn't as resilient as Word when it comes to
assigning hot key combos (for those that don't know, please c...
|
3 |
24.02.2006 18:43:35 |
|
|
Does anyone have a wedding planner template?
I am looking for an excel template that will help me tracking the cost of
every part of a wedding reception. Thanks for you help!...
|
3 |
24.02.2006 16:51:26 |
|
|
Sheet tabs and scroll bars
It would be nice to have the option of eliminating sheet tabs and scroll bars
from new Excel workbook sheets. If this option already exists, I haven’t
found it yet. Thank you
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you ...
|
13 |
24.02.2006 01:16:26 |
|
|
How can I selectively stop creation of Excel *.xlk files?
I have financial workbooks for each year; for only the 2 or 3 latest do I
want backup files. Unchecking "Save AutoRecover... " doesn't do the trick.
I'm not referring to what's saved in "C:\Documents and
Settings\xxxx\Application Data\Microsoft\Excel\", but to the *.xlk files in
the working folder.
Also, is AutoRecover responsible for the extremely annoying, sporadic
disappearance of...
|
2 |
23.02.2006 21:37:41 |
|
|
Embedded status lines should eliminate annoying popup "OK"windows
"OK!" A design flaw in Excel prompts users to verify commands (such as the
results window after find/replace the contents of a cell) and waters it down
by giving the results of the action. This window is unnecessary and watses
time. Incorporating this feature into the active window instead of as a
separate pop-up would streamline performance and remove the need to second
guess the user's...
|
1 |
22.02.2006 14:45:29 |
|
|
Excel 2003 ~ How to change the default units of measure?
Hi all,
In Excel 2003, I want to change the default units of measure from
"centimetres" to "inches" (specifically the Margin widths in Page Setup). In
Word 2003 it's very easy - there's a setting under Tools/Options/General,
but nothing similar seems to exist in Excel. Can anyone help please?
Regards,
Robin
...
|
1 |
22.02.2006 11:42:48 |
|
|
horseracing results database storage
new to all of this , wanting to set up storage database for individual
racehorse results...
|
1 |
22.02.2006 11:27:28 |
|
|
Formatting problem
How do I add a small space above and below test in the same cell...
|
2 |
22.02.2006 10:20:28 |
|
|
How do I create a macro that will automatically input lines?
I am trying to create a macro that will delete lines based on a number that
is inputted in a particular cell. For instance if the number is cell A1 is
10 then input 10 rows for data....
|
2 |
22.02.2006 10:18:26 |
|
|
SKU112.CAB
Cannot open Excel 2003. Recieve message "required installation file
SKU112.CAB cannot be located" and I don't have access to the original
installation disc. How else might I be able to fix?...
|
2 |
22.02.2006 10:17:25 |
|
|
Post Compilation Packaging
Does anyone know how to create an Excel spreadsheet (that i have created) so
that when I give the file to people on a cd they can install it as if it was
a program.
I have heard the term Post Compilation Packaging in reference to what I'm
trying to do but don't know anything about it....
|
1 |
22.02.2006 02:59:27 |
|
|
excel 2003
I'm importing ascii delimited text file into excel. Cols are delimited by
commas and
text is surrounded by double quotes. No matter what I do, numbers inside ""
are treated as numeric instead of text, even when followed by spaces before
the
closing double quote.
According to all help instructions, those numbers should act like text.
Ex. "00001234 " comes out as 1234. Why? It' driv...
|
2 |
22.02.2006 00:48:26 |
|
|
Excel upgrade
I upgraded Excel from 2000 to 2003 and now when I go to programs, I do not
see Excel in Office ...
|
4 |
22.02.2006 00:39:27 |
|
|
Excel Error Msg following Removal of Oracle
Hi Help,
After using Oracle 5.0 Business Objects, i removed it from my system. Now
when I open Excel I receive an Error Message: "C:\Program Files\Process
Objects 5.0\BQAPI.XLL could not be found. Check spelling...."
Removing Oracle also removed the "Business Objects" option from the Main
Menu, but Excel is still looking for the application. Is these a setup fix,
or must I reload ...
|
1 |
21.02.2006 20:30:31 |