reading pane keeps turning on and preview pane keeps turning off
I've been using outlook 2007 for about 6 months and all has been ok until
now. My normal view is to have the reading pane turned off and the preview
pane turned on. however, now things changed all of a sudden. now when ever
I go to the inbox the reading pane is turned on and the preview pane is
turned off. So I go to the view menu and reset the view to what it should
be. if I click on any other folder such as sent items and back to the
inbox, its back to reading pane on and preview pane off. This is the same
behavior for all folders. any ideas how to resolve this?
-- ...Rounding #3
How do I format a cell so a calcuated # is a true whole # (ie 4) for additional formulas, not just appearing as a whole # (4.43560 appearing as 4)?
Formatting doesn't change the value stored in a cell, unless you
have checked the Tools/Options/Calculation Precisions as displayed
checkbox (which applies to the entire workbook).
You can instead wrap your calculation in the ROUND() function:
=ROUND(<your existing formula>,0)
In article <603DF5C7-6D8F-4163-8A03-1794FFED0ACD@microsoft.com>,
"jw" <email@example.com> wrote:
> How d...Active Directy Rename and CRM 3.0
We have an existing W2K3 domain that was set up by a former IT employee that
unfortunately didn't know AD from the toilet. We are looking at performing a
rename to our domain/exchange 2003 structure using the microsoft tools. i
was wondering if there are considerations that would need to be taken into
affect for a CRM 3 install that is on the same domain. This may be something
that no one has tried before but I thought I'd through it out there and see.
because of the nature of what you are trying to do I would open a support
ticket. Even though server 2003 allows ...3 graphs in 1?
I want to graph: sales, % increase, and sales per square foot over time (5
years. How do I show 3 different sets of information on 1 graph? So far I
have sales as a bar, % as a line graph on top but I need sales psf in the
background. The axes would need very different numbers. thanks!
Take a look at Jon's article on panel charts with different axis. It's a bit
of work, but it results in chart that does what you ask, plot 3 different
axis over time.
*Remember to click "yes" if thi...Marketing in CRM 3.0
I am loking for a full blown marketing add-on to CRM 3.0... any
Microsoft CRM 3.0 ships with a Marketing Module that has campaigns, quick
campains and related features. What is the functionality you are looking
Manisha Powar (Madhusudanan)
Microsoft Dynamics - CRM
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. � 2005 Microsoft Corporation. All rights
"mw" <firstname.lastname@example.org> wrote in message
news:email@example.com...Backup Exchange Server #3
I am new to Exchange administration. So please be gentle in reply...
Here is the Question:
My company currently has 1 exchange server. Recently it went down and we did
not have emails for almost 3 days before I could figure out a way to get the
database back (considering that there was no backup as it was failing).
Now it is all working perfectly well. My boss now wants me to put in a
secondary exchange server so that incase the first one fails it should
automatically switch over to the second one and there should be no down time.
My company is based on revenue from orders coming t...Column Headers showing numbers
My Excel spreadsheets are opening up with numbers at the
top not letters. I'm sure I must have clicked something!
Thank you in advance
Tools | Options | General Tab | Uncheck R1C1 Reference Style
"Julie" <firstname.lastname@example.org> wrote in message
> Hello there,
> My Excel spreadsheets are opening up with numbers at the
> top not letters. I'm sure I must have clicked something!
> Thank you in advance
...How do you turn off autoformatting?
I am making a spreadsheet that is essentially a record. In one of the
cells, I am entering the old/new values for something as 4/80, which
Excel instantly turns into April-80. I can format the the cell back to
General, but the number that results is not 4/80. And if I go in and
reset it to 4/80 again, the autoformatting kicks in again and the whole
process starts over. While there are plenty of ways I could work around
this, from changing the way I enter the data on up, it has become a
sort of matter of honor now. How the heck do I stop Excel from
overriding everything I enter?
how can ia crearte a new Cdialog runing under new thread
> how can ia crearte a new Cdialog runing under new thread
It is really not a good idea to have GUI components in a secondary
thread. Just use a worker thread, or a window-less UI thread.
If you have a CDialog-derived class, you can have individual methods run
in the secondary thread, but they should only update the GUI using
PostMesage() or SendMessage().
To add to David's advice (good as usual) you can send a message to the UI
thread that tells it to pop up the dialog for you wi...Help with searching a column
I am having some trouble searching an entire column to see if a value
is in the column. I've tried
=IF(ISNUMBER(SEARCH(A1,K:K)),"TRUE","FALSE") - But it doesn't seem to
be working. It only works if the A1 is in every cell of K.
I have two columns, the first I have a list of values each on its own
The second contains multiple values in each cell.
1. CSS-PB-350, CSS-PB-111
2. CSS-PB-100, CSS-PB-091
3. CSS-PB-101, CSS-PB-021, CS-PB-234
So I would want to find that CSS-PB-350, CSS-PB-100 is in column B ...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <email@example.com> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...unable to send to one domain, telnet to and get 550 5.7.1 unable to relay for when i do RCPT TO:
I have no problems sending out anywhere but this one domain.
Running SBS 2003 w/ Exchange 2003.
users have gotton it back with
The e-mail system was unable to deliver the message, but
did not report a specific reason. Check the address and try again. If
it still fails, contact your system administrator.
<mydomain.com #4.0.0 smtp;451 Please try again>
There was a SMTP communication problem with the recipient's email
server. Please contact your system administrator.
<mydomain.com #5.5.0 smtp;550 Contains .gif file
I t...Can not Delete emails #3
I have outlook 2000 premium and I have a problem trying to delete emails from
my inbox. My highwater mark file I believe is corrupted and I am getting
repeated emails. Everytime I try to delete the extra emails I get this error
The messaging interface has returned an unknown error. If the problem
persits restart outlook.
I have tried to restart but I get the same message everytime.
Please advise of possible solution.
What is the size of your pst-file? Have you checked it for errors already
Robert Sparnaaij [MVP-Outlook]
Tips ...Difficult function question for columns
I would like the create a column that performs the following function:
[If column A=1, then display number in cell B10; If Column A=2, then display
number in cell B11, If column A=3; then display number in cell B12]
If it is of any importance, in the above example B10:12 have a
=SUMIF/COUNTIF function in them.
Thanks in advance.
> I would like the create a column that performs the following function:
> [If column A=1, then display number in cell B10; If Column A=2, then display
> number in cell B11, If column A=3; then display number in cell B1...Drop Down Box #3
There is a drop down box that can be inserted in a
spreadsheet that will go to a second sheet, and will show
a listing of names and allow you to pick the exact name on
the second sheet and show it on the first sheet. Can
anyone tell me how to get this drop down box? Thanks.
You can use Data>Validation, and refer to a named range on the second
sheet. There are some instructions here:
> There is a drop down box that can be inserted in a
> spreadsheet that will go to a second sheet, and will show
> a listing ...How do I stop bullet letter (a, b, c) from turning greek?
When I create a document in which I have used letters for bulletted lists
(ie, a), b), c) etc), when I print or reopen it, the letters have changed to
Greek characters alpha, beta etc. How can I stop this from happening?
Thanks very much.
Wow, I cannot duplicate this in any version of Publisher. Maybe you are using a
different type font.
Mary Sauer MSFT MVP
"allythegeek" <firstname.lastname@example.org> wrote in message
&...Exchane E-TUrn Configuration
Hi. Can anyone please point me in the direction of a document that details
the configuration of two exchange servers in different active directory
domains where one must receive mails for a specific domain and park them and
the other dials-up every hour and retrieves these mails? I believe I have to
use E-turn for this?
...Preview Pane turns itself back on
I've asked everyone to disable preview pane and I have one user who
tells me that everytime she disables it, it turns itself back on. She
can disable it in the inbox, go to sent mail folder, return to inbox
and it's back on. Help!
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
...Global Address List not updating #3
We have SBS 2003, and last week I added various Distribution Groups. I
added them in the Active Directory and Users tool and they appear there and
under Distribution Groups in the Server Managment.
However in Outlook, non of these distribution groups appear in the Global
Anyone have an idea what could be wrong or how to force the Global Address
List to see the changes?
What clients are you using? Have you tried a rebuild in ESM?
"Lee" <email@example.com> wrote in message
> Hi...is dotnet framework 4 compatiable with 3.5 app?
I currently uses 3.5 sp1 with vst 2008, no plan to go to 2010 for at least
half a year.
However, someone wanted a dump of the crash visual studio 2008 standard and
I was not able to get the info they wanted. They suggest if I have dotnet 4
installed I can use another tool to make easier to get the dump they want
Should I install .net 4 or that will give me a lot of trouble?
On 15-05-2010 01:39, GS wrote:
> I currently uses 3.5 sp1 with vst 2008, no plan to go to 2010 for at least
> half a year.
> However, someone wanted a dump of the crash visual studio 2008 s...How turn turn off warnings
I have a form which contains a button to run an update query. When
clicking the button, it warns of running an update query to which one
must respond "Yes". Then it informs you that it is going to update x
number of records to which one must again respond "Yes". I have used
macros in the past to turn off and then back on these warnings, but
lately I have tried to write the code instead of macros. What would be
the code for this?
For reference, this is what I have right now:
Private Sub UpdateMPS_Button_Click()
On Error GoTo Err_UpdateMPS_Button_Click
Dim stDocN...1) Tabs not Transparent -- 2) Tabs Flicker ??
I just started using Tabs
We use Access 2003.
1 - Tabs were not "transparent" on my form. I searched the newsgroup &
discovered we had to set all XP desktops to "Windows Classic" Theme to
Is there any way to return to XP Theme, or any other Theme, and have
2 - To kill the "flicker" issue for unbound Labels we had to convert
them all to "Text Box's"
and put the Label Text in the "Control Source" field and delete the
Text Box Label... and set Properties for the Text Box to make it look
like a Lab...Comparing Data #3
Using Excel 2003
I have a list of names in Column A:
I have another list of names in Column B:
I want to compare the two columns of data to find names in Column B that
are not in Column A. I cannot use the "match" function because one extra
name in Column B (Johnny) throws off the side-by-side match of the two
columns. Sally and Fred are both still in each column even though the extra
name "Johnny" causes them to be offset from their match in Column A.
Is there some other way of accomplishing this comparison?...Charting 3 columns help
I am working on a staffing chart with three columns:
Staffing Time Incident
6 3 1234
15 9 1234
I would like a graph to show
the "Time" on the left
the "Incident" on the bottom
and Staffing in the chart
I have racked my brain and have not figured out how, to make the chart work
that is :o)
Do I need to re-arrange the columns? a different way?
Any help would be greatly appreciated.
In your brief sample, Incident has no variation. How do you want staffing to
appear in the cha...How to turn Off and On the pesky Office Assistant?
I want to try to live without the Office Assistant.
How can I turn it off?
If I find I must have it, how do I turn it back on?
Right clck the office assistant and select Options. Options that are
selected cause the office assistant to display, so the more options you
deselect, the less times the little guy will show up. You will probably
want to leave "REspond to F1 Key" selected (checked), so that you know you
can always recall office assistant by pressing F1.
"tmb" <firstname.lastname@example.org> wrote in message