how to use Excel 2007 Sensitivity Analysis
could any help provide a sample excel worksheet with sensitivity analysis
demo, including use of scenario manager to generate scenario summary.
I have a stacked chart with one series showing positive values, and two other
series showing negative values. When I add data labels, they only appear on
the positive value series. Even when I click on the negative series, I get
the menu to format the data labels, but in no way, shape, or form are they
actually visible on my chart.
I used this data
Group Alpha Beta
A 1 -1
B 2 -4
C 3 -6
D 4 -4
E 5 -3
Made a stacked column chart
Added data labels to each data series; both were visible
Changed chart type to Line and to Bar and data labels remained visible
What to se...Help
I'm posting out as I've been having some issues with 3 nearly identical
clients ever since putting in SBS2008. They have proven very difficult
to trace and resolve.
Client 1 - SBS2008 new install, new domain etc on HPML110, 5 users
Client 2 - SBS2008 migrated from SBS2003 via MS Migration on HPML150,
15 users with all new HP/WinXP workstations
Client 3 - SBS2008 migrated from SBS2003 via Swing It! migration, on HP
ML350G6, also about 15 users.
All 3 have Sonicwall TZ series firewalls, HP gigabit switches, and use
Windows XP and Office 2003. All use Exchange ...Lists in excel
Is there a way to have a list that will eliminate a value once it is already
used in a group of cells?
Have a look here:
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Kameca" <Kameca@discussions.microsoft.com> wrote in message
> Is there a way to have a list that will eliminate a value once it is
> used in a group of cells?
Gary''s Stud...Sorting a column by using formula #3
I am trying to use sort function just to delete blank cells in between
Sort order doesn't matter actually.
Data is coming by the use of simple cell reference of "another sheet
Praise's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1558
View this thread: http://www.excelforum.com/showthread.php?threadid=27144
you may use the following addin to filter out blank cells:
&g...I need to C&P a section of Excel to Word but I need to get it to fit on a standard 8.5x11!
Is there a way to make this happen? The sections that I need to C&P are all
the columns are 14 wide and the rows are 40, 41,44 and 65. How do I get
these to fit on the page?
> Is there a way to make this happen? The sections that I need to C&P are all
> the columns are 14 wide and the rows are 40, 41,44 and 65. How do I get
> these to fit on the page?
Smaller font, cut margins to the minimum, print landscape
Print Preview > shrink to fit, are all options just depends
on how wide the fields are. It just may be to big to fit
...xlodbc.xla - Excel ODBC Add-In
I am trying to run SQL queries directly from a worksheet in Excel. I have
found an add-in for Excel 2002 that is no longer supported in 2003 or 2007
which is just what I want (xlodbc.xla).
1. Why was this discontinued?
2. Is there a built-in way to do this in newer versions [running queries
from a cell, NOT going to Data > Import > etc...]?
3 Any other thoughts, help, advice?
If you are looking to run a parameter query there are much better ways, You
may find this helpful.
About 3/4 wa...language issues outlook calendar
I've run today into two quite interesting issues. Users of OL2K3 are having
the wrong language version in their calendar folder.
For one user an upgrade from French to Spanish has taken place and now she
has a French PLUS a Spanish calendar.
Also I have a user who has simply Dutch instead of French.
Do you have any idea where I can change the language settings in Outlook
Thanks for your comments.
Start Outlook with /resetfoldernames. Then transfer the data to a singular
folder and remove the other one.
Robert Sparnaaij [MVP-Outlook]
www.howto-o...Configuring Trend IMSS7.1 with Exchange 2007
Its new setup
Firewall: Fortigate 80C
Server : Exchange 2007 (Mail Box , Hub transport & OWA)
Server : Redhat Linux With Trend Micro Inter Scan Messaging Security
i want to configure.
Incoming Mails Flow chart : Firewall --> Trend Micro IMSS --> Exchange
OWA has been Published with ISA2006. Intranet mails Working .
Kindly help me to configure External mails sending and Receiving
Kindly Help me how to configure the connective in between all the
...Excel 2003 question about help menu
I use Excel 2003 OFF-LINE. I find myself extremely limited and
frustrated with the "menu approach" that it uses as well as the set
number of items it will display as the result of a keyword search.
The main problem for me ATM is that I know that the functions are
categorized into say eight categories, e.g., text, but I don't always
remember all of them. In the past, a search in Help would return a
list of those categories from which I could quickly and easily navigate
around to doublecheck my understanding. Search results in Excel 2003
are erratic, and trying to find the list...Outlook email templates
I have several templates in Outlook 2003. Will they work in 2007 as is, or
will some tweaking need to be done?
I have a regular task that I do on a pivottable that looks like this (but
No Code Total
1 DN 841.92
2 RDB 0.00
3 PRP42 3,435.76
Grand Total 672,328.19
I paste this info into a database which requires the number to be repeated
on each line.
At the moment I use a macro to copy the data down to the next entry as shown
below starting in the cell that has No in:
Selection.f...Excel 2007 chart line types
When using Excel 2003, I was able to copy charts, and then paste them into CorelDraw as metafiles, ungroup these, and use the lines from the charts in my graphics. Since upgrading to Excel 2007, I am still able to do this, but the lines now appear to have a more complex format (the compund type is mentioned in the line properties dialog), made up of border and line types. On exporting to CoreDraw, these lines appear much less uniform than previously, changing thickness along the length of the line. Is there a workaround to allow me to plot chats with non-compund type lines as was po...ACCESS 2007 RUNTIME 01-07-08
First of all -sorry for my english.
Acc 2007 RT is in english version. is there othere language version? if not,
how to deploy databases to non-english clients?should i hadle all massages
Tnx for answers and any sugesstions.
On Mon, 7 Jan 2008 04:35:56 +0100, "robert" <email@example.com> wrote:
You can create ribbons to replace the old menu system, and you can
write them in the local language(s).
For error handling, I would create a central error handler function,
and in it you can display your own messages to replace the default
>He...Can't get bar code font to work in EXCEL 2003
I have a simple formula that converts a part number to a 3 of 9 bar code font
in Excel 2003. Works great on my computer but a co-worker, who also has
Excel 2003, can't get this to work. On her PC it show the 3 of 9 font in
the drop down box but in the cell it is not converting it to a bar code
Most likely the font is not installed properly...
She needs to reinstall the font. It can be done through Control Panel ->
Fonts if you have the font available.
> I have a simple formula that conve...Line Graph in Excel
I have created a line graph in Excel (with my input data on a separate
worksheet). I have 3 columns: Planned, Actual, and New. I am tracking
'requirements' and I only want 2 lines on the graph. I have plotted the
Planned and Actual, however I want the 'New' to be added to the 'Planned' in
the graph. Maybe my example below will help?
Planned Actual New
A 10 8 0
B 15 12 2
C 20 17 0
D 25 23 ...ADVANCE FILTER SORT WINDOW
Hi! Could anyone please help me? I have this continuous form called
"frm_Status01" with a button that has this code "DoCmd.RunCommand
acCmdAdvancedFilterSort" to open the advance filter sort window. After I
have completed selecting all the fields I wanted, key in all the cretirea,
sort, etc then click the apply filter button shown at the advance filter sort
window and my "frm_Status01" is already displayed and active. The advance
filter sort window didn't close after I applied the filter. Is there any way
to close it immediately after I applied the...Saving Issue in 2007
I created a PowerPoint 2007 presentation yesterday .pptx and saved it to my
network drive. I'm the only person who worked on it. Today I opened the
file and made revisions to it. When it's time to save the file, I went to
Office Button > SAVE. I got an error saying the file is in READ-ONLY and
cannot be saved. I have to rename the file. Does anyone know why this is
happening? No one has the file open besides myself.
This happened to me on Monday and yesterday. Any help or suggestions would
be greatly appreciated.
This will often happen if you'r...repeating a data pattern in excel
Im using excel to run a class register for a playgroup. Each pupil is booked
in for a number of days per week. To show their forecast for the year, I'm
manually entering the days they're going to be present each week - is there a
way to do this automatically?
For example, Ben is booked in for Mondays, Wednesday and Fridays - how can I
copy this weekly pattern throughout the year without manually tabbing across
and ticking the relevant days?
Hi, Kel. To do this manually, but easily, type the first 3 "sets". Select
them all and copy down using the fill handle. You coul...OWA Issue #10
I have a single user who is having issues with OWA not loading his
mailbox. What happens is that his account appears to be accepted and OWA
tries to load the mail screen but fails. I can reproduce this on several
machines so I don't think it's related to his PC. The only odd thing I see
with his account is that he has a ton of folders in his mailbox (not under
his inbox but at the same level as the inbox). Is there any limitation to
the number of folders a user can have? Any other ideas?
On Mon, 1 May 2006 11:28:02 -0700, Dan <Dan@discussions.microsoft....View Access 2007 using 2003 version
I know MS has a fix to open Excel, Word, and PP using Office 2003 that was
created using the MS Office 2007 product. But do they have something to do
the same for Access? I'm betting that a Access 2007 can be saved down to 2003
but I'd rather not do that.
On Mon, 18 Feb 2008 12:13:04 -0800, TX - CAP
But there is a free runtime version of Access 2007 that may suit your
>I know MS has a fix to open Ex...Receiving email in outlook 2007
Trying to send/receive, send works fine but can not receive any emails.
Receiving error 0x800ccc0f the connection to the server was interrepted. the
server responded - ERR concurrent connections limit in avast exceeded
(pass:20,processes:Rps.exe), there is a collision with another program.
I checked all settings and they seem fine. Anyone else getting this message
or know what I should do. Thanks for you help.
> Trying to send/receive, send works fine but can not receive any emails.
> Receiving error 0x800ccc0f the connection to the server was interr...excel vba
i would like to bring up the file save as dialog box and defalut to a
file type of xls..
here's what i'm using...
'i have a path and file name in Newfile
NewFile = Application.GetSaveAsFilename(myfilename, "*.xls")
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
newFile = Application.GetSaveAsFilename(Initialfilename:=myfilename, _
fileFilter:="Excel Files (*.xls), *.xls")
mjschukas wro...2003 to 2007 graph editing
hello all: I am attempting migrate files from custom template in 2003 to
similar template in 2007. I am running pp2007 with sp2. I have created
a new potx and thmx file as well as several chart crtx files. When I
open a ppt file and attempt to convert the graph files, I get hung up.
If I use "edit existing" then of course ms graph pops up. If I choose
"convert" then a new popup says "one or more charts in this document
cannot be converted to the current Microsoft Office chart format". the
process does not allow me to convert to excel based data she...working with excel
i am using check boxs for yes and no questions,how do i
simplify the size and centering them on a row and column?
There are two different checkboxes--one from the controltoolbox toolbar and one
from the forms toolbar.
This code will fill the topleft cell with the checkbox:
Dim OLEObj As OLEObject
Dim myCBX As CheckBox
For Each OLEObj In ActiveSheet.OLEObjects
If TypeOf OLEObj.Object Is MSForms.CheckBox Then
.Top = .TopLeftCell.Top
.Height = .TopLeftCell.Height