Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Tr again: Modifying Calendar's "reading" view in 2003
In Outlook 2003, Calendar allows me to show the event's content in a
"Reading" pane at the right or bottom of the calendar. But the layout of
the Reading pane wastes a lot of space. Can its layout or content be
No, the content can't be modified.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...Microsoft Money 2007 Deluxe Canadian version?
I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
cannot find it. Where can I get one?
There isn't one. See http://money.mvps.org/faq/article/422.aspx
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"masai" <firstname.lastname@example.org> wrote in message
>I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
>ca...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Office 2007 trial is very slow. Is this because it's a trial
I just started using the trial version of Office 2007. It takes forever for
it to open on my computer but Office 2003 opens just fine. Is this just
because it's a trial or is it naturally slow because of the additional
It's likely due to the expanded feature set and increased hardware
requirement over Office 2003.
> I just started using the trial version of Office 2007. It takes forever for
> it to open on my computer but Office 2003 opens just fine. Is this just
> because it's a trial or is it naturally slow because of the ad...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
Southampton...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <email@example.com> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Send from Word
When I hit the send button in Word or Excell I get a pop
up that say choose profile with Outlook in the drop down.
That is the only name in the drop down. If I hit OK I get
the following Message.
The MAPI Spooler could not be started. Close and then
restartall mail-enabled applications.MAPI 103 (0000004C7)
If I choose to set up a new profile I get a Microsoft
Exchange Setup Wizard. As I try to setup a new profile I
come to the following,
The following unrecoverable error has occured:
The .DLL file for this service is either damaged or could
not be found.
What versi...Embedding worksheet into Word
Has anyone had the experience where when they embed a worksheet into
Microsoft Word, a portion of the worksheet gets cut off?
Is there an easy fix to this?
...Office 2007 SP2
Has anyone else lost the little check box which is usually found next to
each task in the task list in Outlook today? I'm assuming it's a bug?
"Carmen Gauvin-O'Donnell" <firstname.lastname@example.org> wrote in message
> Has anyone else lost the little check box which is usually found next to
> each task in the task list in Outlook today? I'm assuming it's a bug?
Nope - still there...
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level...Unable to repy using word editor
When repyling to an e-mail I receive the following
message, "This form requires Word as your e-mail editor,
but Word is either busy, or cannot be found. The form
will be opened in the Outlook editor instead". I found
article 284900, that states you may get this message when
you have office 2000 and office xp installed on the same
computer. This is not the case on my computer, Office
2000 does not exist, only office xp.
Can anyone help me?
There appear to be a whole host of causes for this error message. Most have
no solution. Here are a few that do:
http://support.microsoft...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Fewer normal template problems with Word 2000 or 2002?
I have enjoyed some things about Word 2007, but I keep having problems
with macros and templates. I am wondering if (a) macros increase the
likelihood of corrupting the normal template in 2007, or (b) if the
older versions of Word had as many template problems. I have used Word
in 2000, with Office 2003, and now with Office 2007 and I don't ever
recall having as many problems as I've had with 2007.
What I'm thinking is that if it is simply a macro problem causing
corruption, I would simply use 2007 without the macros (they're nice
but I can live without them). On the...How to view the same email message at the different PC users
My husband & I use the same PC(Windows XP) but have an
individual user accounts. We have several email addresses
for individual usages and shared usages and all enable to
receive and view by Outlook 2000 inbox. We have noticed
that the emails came in while I'm on Outlook (or
minimized at the bottom) can not view when my husband
goes to his Window user and open the Outlook. And vise
versa. We want to be able to look at all emails that came
into the Outlook inbox at both Window user's Outlook
inboxes. How can we do that?
...web preview not same as publisher view
Reading past postings it appears others too are having serious problems with
Web preview in both 2002 and 2003. I think the problem is that text handling
within text boxes in normal Publisher view simply does not reflect that as
seen in Web Preview (currently Explorer 6) On a totally blank (wide setting)
webpage, using standard Times New Roman 12pont (no italic underline or bold)
I typed six lines of Mary had a little lamb into a 3.85x3.029cm text box with
all margins set to 00. I outlined the box with a 1/4pt line Whereas the
text just fitted into the box in Publisher view, in Web ...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 18.104.22.168 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...compound if equation?
Hope everyone's afternoon, evening, etc... are going well.
I have a dual worksheet function that requires something more compound that
I've used before.
Thus far, I've tried using an if equation, that looks through a dataset with
a sumproduct, and if the dataset matches, I perform one equation, and if not,
=IF(SUMPRODUCT((APN!$E$4:$E$95&""=$A11&"")*(APN!$F$4:$F$95=$C11)*(APN!$B$4:$B$95))<>0,SUMPRODUCT((APN!$E$4:$E$95&""=$A11&"")*(APN!$F$4:$F$95=$C11)*(APN!$B$4:$B$95))/TRIM(LEFT...Outlook 2007: is there a way to use it as a Diary
I'd like to keep a daily journal of important notes, etc. In other
words , I would like to keep a Diary. Does Outlook 2007 have this
Sure - Ctrl+8 to view the journal or you can create a Mail and Post folder
type and post to it.
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:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH...Upgrade Path from DPM 2007 to DPM 2010
Is there going to be an upgrade path from DPM 2007 to 2010?
Yes. Look at the following DPM 2010 documentation:
"DPM supports upgrading from DPM 2007 SP1 on a Windows Server 2008 x64-bit
operating system to DPM 2010. If DPM 2007 SP1 is installed on a Windows
Server 2003 x64-bit operating system, you must upgrade to Windows Server
2008 before upgrading to DPM 2010".
Also, here are my notes on DPM 2007 to DPM 2010 upgrade:
http://santhoshsivarajan.blogspot.com/2009/09/dpm-2007-t...Unread mail not showing up in Inbox
My Unread folder in located the "Favorite Folders" section in Outlook
shows that I have more unread mail than I can see in my Inbox. My
Inbox is normally sorted by "Received" so I can see the most recent
emails as then arrive. If I change it so that it is sorted by the
"From" column, I can see all the emails in the Inbox that are
appearing in the Unread folder. It is strange that they don't appear
using "Received" though. Emails that fall under any rules are not
affected by this so rules are irrelevant in this case I suppose.
Also, some additio...Exchange 2007 Mailbox Folder information not updating
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I am using Entourage 2008 Web Services Edition in an Exchange 2007 SP1 UR4 environment. I have only been using the Web Services Edition for about a week and prior to that I was using the regular Entourage 2008 client for four months. In any case, the problem I am about to describe occurs in both versions of Entourage 2008. <br><br>Recently my employer's executive group decided to implement Managed Folder Policies to assist in controlling mailbox size. I was the first to...