Drop-down list #5
I created a drop-down list in a separate sheet in my workbook. I named it
Vehicles. Now I want to add to the list, but I can't figure out how to do it.
I know ig must be so easy, but I'm stumped. Please help.
If it's a one-time occurrence, you can press Ctrl+F3,
click on the name, and extend the formula. Otherwise, I
would make the range dynamic. You can learn how to do
>I created a drop-down list in a separate sheet in my
workbook. I named it
>Vehicles...office 2000 [excel] cannot open previously OK file. Help
When trying to open a Microsoft Excel Work Sheet that I had accessed modified
and saved to only yesterday [Office 2000] a window pops up with:
"name.xls cannot be accessed. The file may be resd-only, or you may be
trying toaccess a read only location. Or, the server the document is stored
on may not be responding."
Older files stored on the same mediums ;HD, Flash memory or 3.5in. diskette
are accessed with no problem.
This is on a network drive?
...Excel and some disappeared sheets
Anybody has the same or similar experiences :
- I worked with excel file / closed as usually
- new day opened and unfortunatelly some very important sheets
disappeared / why ? Don=B4t know
- I had about 7-9 sheets just now only 3 ones are there but not so
important as another ones
- the file has original size / I quickly looked into file by normal
text editor only for reading
and all relevant data are there, however if I open file by Excel, NO
original sheets or data
- this file is VERY IMPORTANT for me
- why happened ? Don=B4t know since I ask anybody for help
Thanks in advan...PAGE SIZE DIFFICULTY
WHEN I CHANGE MY PAGE SIZE AND PAPER SIZE MY PUBLICATION REMAINS THE SAME.
COULD SOMEONE TELL ME HOW TO SHRINK MY DOCUMENT TO MATCH MY PAPER SIZE
>WHEN I CHANGE MY PAGE SIZE AND PAPER SIZE MY PUBLICATION
REMAINS THE SAME.
>COULD SOMEONE TELL ME HOW TO SHRINK MY DOCUMENT TO MATCH
MY PAPER SIZE
Choose Page setup from the File drop down menu and set the
page size to suit your needs. Note that elements on the
page do not change. You will have to rearrange to suit.
> WHEN I CHANGE MY PAGE SIZE AND PAPER SIZE MY PUBLICATION RE...publisher. why does webpage preview show only half page
When I'm viewing my webpage design in webpage preview I am getting a large
empty space on the right hand side and bottom of the page
On Fri, 17 Feb 2006 17:50:02 +0000, yousane wrote
(in article <65E39911-B9CA-4785-BD48-358D03F3695A@microsoft.com>):
> When I'm viewing my webpage design in webpage preview I am getting a large
> empty space on the right hand side and bottom of the page
And your problem is...? That's how it's supposed to be. Web pages designed in
Publisher do *NOT* fill the entire screen. I suggest you learn to use the
right tool for the job (I&...Heading at top of page
Working in Word 2003, I put two spaces between a paragraph and the next
'heading 2'. This works fine until the 'heading 2' spills on to the
next page. There is then two spaces gap at the top of the page.
Is there a way to tell word to keep the heading at the top of the page
if it spills over? Don't want to put in a hard page break.
How are you creating the spacing? If you are pressing Enter twice, then don't.
Use Spacing Before instead (Paragraph dialog box, Indents and Spacing tab).
Microsoft Wo...How do I copy the result of a check box into another check box?
I'm trying to copy the result of a "check box form field" into another check
box. For example: if I check (or uncheck) one box in a form, another box
later in the protected form will also be checked (or unchecked) , much like
the ref + F9 command for the text form field. Is this possible? Thanks.
This cannot be done without macros. If your project will allow macros - see
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
G...can I snap wrap points to a text box
rather than having to add individual wrap points to the edge of a frame,
which is never as accurate anyway, can they be set to 'snap' to a frame (eg
the ellipse) so that they are perfectly inline, (and which would of course be
a lot quicker)?
Edit points will not snap. There are options for edit points, select a point,
right click. If you hold down control, the cursor will turn into an x, you can
delete a point with a click.
Truly a good draw program would be preferable.
Mary Sauer MSFT MVP
&q...OL2002 Problem : HELP, SOS, MAYDAY
I have an IMAP account and OL2002 as client.
I have checked for my account ( tools, send/receive
settings, define send/receive groups, <my_account>,
edit) download item description only.
It works only the first time I start OL2002, but it does
not work anymore for subsequent automatic/manual
Please could someone really help me ?
Thank you in advance,
...how do you get a landscape page?
Please help, desperate!
If you are using 2010, Page Design tab, Size, More pre-set page sizes. Letter
landscape is the first choice.
In all other Publisher versions landscape will be on the page setup screen found
in the File menu.
"becky.x" <firstname.lastname@example.org> wrote in message
> Please help, desperate!
...Help With Margin Formula
I need help with a margin forumla (calculated from retail). Say I have a
cost of $10.00, and I need the formula to calculate a 40% margin from
retail. So the retail should end up at $16.67. Not sure how to get from
$10.00 to $16.66, I just know the cost and the margin I need to make.
"JR" <email@example.com> wrote in message
> I need help with a margin forumla (calculated from retail). Say I have a
> cost of $10.00, and I need the formul...GETPIVOTDATA data_field help
When I enter a reference to a cell, eg A2, as the value for the data_field item in the GETPIVOTDATA I get a #REF error. However, when I instead type the value of A2, eg 2003, manually into the GETPIVOTDATA formula, it works. Can anyone please help--I want this formula to vary based on what is in A2.
This function is so variable in action, and difficult to handle, that
have given it up in favour of VLOOKUP. In fact, having no problem i
use with pivot tables
Message posted from http://www.ExcelForum.com
Try copying the headings from the pivot table, and pasting them into the
ce...Exchange server crashed, please help....! Need to restore two priv.edb and pub.edb files into one....!
I was wondering if I could get some help with the following problem we are
having on our company.
Here is the scenario; Our Windows NT 4.0 SP4a server running Exchange 5.5
SP4 crashed (Server 1) due to the exchange database reaching its 16 Gig's
max limit. I went ahead and moved some mailboxes' e-mails to a few .pst
files in order to make some space. This worked ok. Then, I decided to build
another exchange server (Server 2) to moved some mailboxes and alleviate the
load. Once the server was ready and configured as part of the current
exchange site, I went ahead and move...Help!!!!
I am running Exchange 5.5 on NT 4.0 sp6a. Norton Anti-
virus deleted my edb.log file. I have done an on-line
restore with Arcserve 2000 and now my directory service
won't start. getting 1166 internal processing error. I
have been to support and could find anything that helped.
Thanks in advance
You may want to run eseutil /mh <drive and path to your dir.edb and
include the dir.edb > c:\edb.dmp. Find this file and see if your dir is
also inconsistent. If so you will need to restore your dir.
Nan Bennett (MSFT)
Microsoft Exchange Support
Please do not send e-mail...Refreshing list boxes
I have created a database so that mulpile users can add detailss to
the table - tblDetails from the form frmDetails or amend details in
form frmAmend. I have a list box on the main page frmMain which has a
list box lstSearch which shows all the records in the database. When
users add new record to the database other users cannot see the added
records unless the move to another section in the datbase and the
return to the main page thus refreshing the list box. Can anyone tell
me if there is a way I can put a "Refresh" button on the main page
that updated the list box if the use...Removing text from cells leaving numbers (help with function)
I need a function that will remove all text from a cell and just leav
numbers. Formatting cells to number does not work.
For example if I have:
(Sired] Tennessee 37013 (herein
I just want 37013 left.
Anybody know a function to resolve this
Message posted from http://www.ExcelForum.com
The following will strip the text from the active cell and place the number
in the adjcent cell one column to the left. If there are subsequent numbers
in the original string you will get erroneous results. Put the cursor on the
cell to be processed and run the macro.
********************************...how to view the stack when there is a messagebox in front
Have anyone tried breaking the execution when there is a messagebox popped
up my the
::MessageBox(....) function or AfxMsgbox(...)
The call stack just shows
Is there any easy way to see the call stack at this point.?
Install the symbols for the OS files ( like user32.dll, kernel32.dll
Check Abdoul [ VC++ MVP ]
"Fleming" <firstname.lastname@example.org> wrote in message
> Have anyone tried breaking the execution when t...I really need help with a formview problem
I have a formview that I place a toolbar onto. In my OnInitialUpdate(),
after I create the toolbar, I say
The formview is still not sized properly. It looks like the problem is the
toolbar on the top of the formview. It is not being taken into account in
sizing the formview. The difference at the bottom of the form that is not
displayed is the size of the toolbar. Any suggestions?
Should work if your toolbar was created (and docked) back in your CMainFrame::OnCreate() method.
----- William Gower ...Bank One Download is not working
We are trying to download transaction data directly from
Bank One and the file is not being recognized by Money -
i.e. the Bank One website states that the download is
complete, but Money does not recognize it. Note that a
file is being saved on our hard drive but we can't figure
out how to read it. It is entitled mnyimprt.exe-(numerous
numbers and letters follow).
In microsoft.public.money, Miki wrote:
>We are trying to download transaction data directly from
>Bank One and the file is not being recognized by Money -
>i.e. the Bank One website states that the downloa...help #2
I need help with the following:
I need to plot a 2-D column graph comparing the profit margin (y-axis)
for the 3 items (x-axis) for Malaysia and Singapore, using the data
Item Mfr's Agent's Retailer's Selling GST Profit Total
Cost Charge Markup Price Margin
Lipstick 9.85 15.76 12.81 38.42 1.54 27.03 105.40
Toner 11.90 19.04 15.47 46.41 1.86 32.65 127.33
Cleanser 15.90 25.44 20.67 62.01 2.48 43.63 170.13
Total 37.65 60.24 48.95 146.84 5.87 103.31 402.86
Item Mfr's Agent's Retailer's Selling GST...problem opening up program/file
I am having some trouble opening up Word. It was working okay until I
loaded some fonts to FontBook. Okay, now I removed all my fonts but I
still get this error message about corrupt fonts I have on my computer.
When I open Word, I see the blue starting-up window: Word:Mac 2004.
Right underneath the product ID #, I see that it is initiating... when
it gets to the point "Optimizing font menu performance" I start getting
this error windows popping up one after another. (E.g. The font M
TimesSmallText is corrupt and should be removed.) I keep on clicking
okay for a whole lot...Result in message box
this is second time iam posting this ,,kindly help me
a form contains button which runs a query like
select count(field1) from table t1 ... then normally we will get a spread
sheet window containing result in a single cell, let say answer is 85.
now when command button is clicked then a message box should appear
displaying the result 85..
please give coding also if required.....
naveen prasad wrote:
> this is second time iam posting this ,,kindly help me
What was wrong with the reply you've already received? Please reply in
your origina...How to show query parameters on an Excel page header or worksheet?
Is it possible to display query parameters on a page header or on a
worksheet? I have a worksheet that uses a query to retrive data from an ODBC
database. The Query prompts for the Start Date and End Date. I would like
to be able to print the worksheet and display the Start Date and End Date the
user typed in. Thank you for your assistance.
...Credit Card Downloading HELP!
I had 2005 and this worked ok but not on 2006. I download my 20 credit
card transactions in QIF format. Money says it has 20 to review so I
click that and they simply do not appear in the register! The the
heck?!? I've tried quite a few things already to no avail. Deleted
history and temp, deleted the statement and previous
transactions/statements, repaired my money file a few times, tried to
import in a different file but it just doesn't show up. Suggestions
In microsoft.public.money, email@example.com wrote:
>I had 2005 and this worked ok but not on 2006....Errror Help: character ' ', hexadecimal value 0x2 is illegal in xml documents
what does this error mean? how can i fix this?
* raj wrote in microsoft.public.dotnet.xml:
>what does this error mean? how can i fix this?
You have an octet 0x02 or perhaps a character reference  in the
document. This is not allowed in XML 1.0; the latter is allowed in XML
1.1 but your version of the .NET framework probably does not support
that, and most likely you have not declared this version either. In
other words, your document includes random binary data and is there-
fore not an XML document. You have to correct the document before you