Changing from One Side to Two Sided Printing
I've got a spreadsheet with multiple tabs.
To change from one sided printing to two sided printing, it seems that I
have to go to each tab, click on page setup, on the page tab select options
and then change from one sided to two sided printing. I can't select all of
the tabs and do this change globally.
Am I doing something wrong?
Is there a better (easier) way to do this?
Group the sheet: click on the first tab; hold SHIFT;click on the last tab
Now set the printer option
BTW: You have a WORKBOOK with multiple WORKSHEETS. "tabs" are the do-hick...Unable to open Outlook2003. Error: MAPI unable loading msncon.dll
I am trying to set up Outlook 2003 on home computer but keep getting the
following message when trying to open application.
MAPI was unable to load the information service msncon.dll.
Since I am not open to open, I cannot get to the help feature.
Have you downloaded the latest MSN Connector from their site? Or, if not
using it, have you uninstalled it? Try opening Outlook in Safe mode
(start->run->outlook.exe /safe) and go into the Advanced options and uncheck
it from add-in manager or COM add-ins.
Milly Staples [MVP - Outlook]
Post all replies to the group to ...How can I change the default pushbutton in a dialog?
Hi to all,
Can someone please tell me what is the use of
CDialog::SetDefID() and CDialog::GetDefID()?
I tried to use them to change the default button of a
dialog without success. Here's what I did:
- Created an MFC dialog-based application. I called the
project "Def" and therefore a class called "CDefDlg" is
created. When I run the application a dialog box with
"OK" and "Cancel" buttons is displayed. The "OK" button
being the default button.
- From the resource editor I added two buttons "Button1"
(IDC_BUTTON1) and ...Unable to Edit/Add records on Form in a New ADP
I just started playing around with rebuilding a MDB file as an ADP. I built
a form and subform from scratch, but I'm unable to edit or add records.
SELECT Id, LoadDate, TrailerDOTNumber, SealNumber, SealDate, SealId,
LoadLocation, LoadStatus, DispatchStatus, DispatchLocationId, DispatchUserId
FROM TrailerActivityHeaders ORDER BY LoadDate
Recordset Type: Updatable Snapshot
I'm getting the 'This recordset is not updatable'
Never mind... (Does anyone have a spare bandage btw? I cut my head banging
it on the wall due to my stupidity...)
"D...Case Modified Date/Time update on changes
Having the ModifiedOn date and time update on changes to related notes,
activities or even just the OnSave event would be much more useful when
reporting on neglected cases.
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 do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Com...Allow Quantity Changing?
How do i change the config to allow only a selected few users to be able to
change the quantity on order of an item in RMS?
"JacquesdKruger" <JacquesdKruger@discussions.microsoft.com> ha scritto nel
> How do i change the config to allow only a selected few users to be able
> change the quantity on order of an item in RMS?
Use the built in security. Nice stuff.
"Antonio Mazzeo" <amazzeo[DOT].email[DOT].it> wrote in message
news:%237GGXh0wEH...Unable to open calendar
Folks, i cannot open or view my calendar.
When I start Oultook a Pop Up appears saying "Could not read the Calendar"
On clicking Ok, the pop up vanishes and nothing happens.
If i then go over to my calendar, it says "Cannot display the folder"
I have run Oultook Diagnostics and nothing shows up as irregular. I ran the
repair function (off my setuo CD) and nothing happened. I also re-installed
Outlook and rebooted my comp and nada.
When staring in safe mode i also get he same errors.
I am using Off 2007, Win 7
"phamiltonsmith" <...Columns change colour with value
Is it possible to make the columns in a bar chart change colour once th
data goes above a certain value i.e. if the data is below target th
column will be red, above target the column will be green.
koootzz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3098
View this thread: http://www.excelforum.com/showthread.php?threadid=50649
See Jon Peltier's example of conditional charts,
koootzz wrote...Dynamically Changing Prompts / Hidden Properties of Report Paramet
I would like to be able to dynamically change the Prompt and Hidden
Properties of a report parameter based on another parameter.
Ideally, I would like to be able to do this within Reporting Services, but
if this is not possible I could perform a solution outside reporting services
to manually change the report before the report is rendered.
I've looked online and haven't been able to find solutions.
Any help would be greatly appreciated.
...Possible to change chart title and label box widths?
This seems like a basic question, but is it possible to change the
width of chart tables or series labels? I can select the label text
boxes, but I can't resize the text boxes.
>From searching the forum, it appears that for some reason Excel doesn't
let you change the widths?!
Any creative solutions?
You could delete the built in chart text elements (chart title, axis titles,
data labels) and insert text boxes instead. Select the chart before clicking
on the text box button, so the text box becomes part of the chart, not just
another floating graphic element.
...unable to download emails and unable to stop synchronization
I am going to try one more time to get this fixed. My Outlook 2003 has been
unable to download emails. While it is trying, a small box in the tray
section shows up and it states that it is trying to synchronize folders.
After a time out time Outlook gives me errors. This is the error message. It
has these numbers 0X800CCC15 , or 0X8004210A, or 0X8004210B, which these
error messages state that either I did not have enough timeout or look and
see if server name is wrong. All of you have given me these suggestions. no
joy. Thank you very much however.
I went ahead and finally found a sect...Change Icon for XLT and resulting XLS
I have created an XLT which is used very frequently at my workplace.
There are multiple files on our drive made using this template, and I
need a way for them to differentiate themselves from other excel
files. After many failed attempts to convince my coworkers to save
their resulting spreadsheets using a simple naming convention, I come
to this group.
Is it possible, at all, for the spreadsheets that are created when the
XLT is opened to have a unique icon (I have already created the icon)?
I've read many posts here about changing the icons for individual
workbooks, for excel...Name Change
We have Exchange 2003 and Outlook (2000 & 2002) on our PCs. To accomodate a
newly married employee, we established an account for her new name. we then
added that mailbox to her profile. It took but then would not open. We have
done this on other PCs with no problem. Her PC has Outlook 2000.
I have a similar setup here. What I usually do is just change the
person's name in Active Directory and add the new email address(es) to
that original user profile.
But in your case, I wonder if the existing user account has rights to
that new account. Can you open the new accoun...unable to scroll the page
on microsoft office frontpage 2003 - when i up loaded my web pages to my web
site www.millertimeauction.com , there is no sroll bar for up & down of page -
it scrolls for me in IE8
scroll bar will only appear if it needs to
Microsoft MVP Expression Web
"FrontPage Error" <FrontPageError@discussions.microsoft.com> wrote in
> on microsoft office frontpage 2003 - when i up loaded my web pages to my
> s...Change of recipient/sender display name
Environment :- Windows 2003 x64 with exchange 2007 (All in one role)
Outlook client :- 2003, 2007
We have created a list of mail contacts (which under GAL) in exchange
2007, these mail contacts are associates with external email address,
each of contact has a naming standard for display name, for example,
display name is HD Finance Manager, external email address is
I want to configure outlook client to show the display name according
to mail contacts whenever the email address is match to mail contacts
list (GAL), for example, an email sent from the email a...how do i change excel into picture format
i am trying to change an excel documnt into a jpeg or other picture format
can anyone help me? i dont even know if its possible
Take a screenshot.
> i am trying to change an excel documnt into a jpeg or other picture format
> can anyone help me? i dont even know if its possible
Or just copy the cells you want to include in your jpeg and paste into Paint.
> i am trying to change an excel documnt into a jpeg or other picture format
> can anyone help me? i dont even know if its possible
Select the cell to be shown in pict...Unable to start POP3, NNTP, IMAP4...
I'm evaluating to install Exchange 2003. After the installation I find the said protocol haven't been started. I tried to start
them in "Servers --> Server Name --> Protocols" but no help.
Please comment.... Thanks!!
Windows 2003, Exchange 2003, Active Directory DC with all roles of FSMO as it's the first DC in the forest. Thank you very much!!
Are you boring? Let's come to talk together... ^^
Those services are disabled by default in Exchange 2003. Go to
Administrative Tools, Services and enable...Unable to conect
I have set up my email account to work with aol using the guidlines for
outlook 2002 but it is still unable to connect. Any suggestions? Thanks.
John <John@discussions.microsoft.com> wrote:
> I have set up my email account to work with aol using the guidlines
> for outlook 2002 but it is still unable to connect. Any suggestions?
Since you pay AOL for their service, my suggestion is to ask AOL.
...How do I set up a rule to sort mail by smtp email address?
I have a user with 2 smtp email addresses set up in
Exchange. He would like to set up a rule in Outlook to
move the mail from the seondary smtp address to a separate
folder. Is this possible? I really don't want to create
another user just to have a separate inbox.
Take a look at WhichAddress application at http://www.ivasoft.biz
"Kathy" <firstname.lastname@example.org> wrote in message news:<email@example.com>...
> I have a user with 2 smtp email addresses set up in
> Exchange. He would like to set up a rule in Ou...Format changing
I have some issues with an Excel file that I will try to explain.
The file contains worksheets; 12 monthly progress reports, 1 data sheet, 1
information sheet, 12 comment sheets (to show progress against objectives set
in the report). It is stored in the 2003 format.
The reports have some text that is linked to the information sheet and the
comment sheets and charts that update from the data sheet. Each report
typically has 6 charts with the relevant comments. The information sheet is
just to give the header information as the need for new files is reached and
this information is commo...connecting an unlinked story
I have a story with a broken link on page 9 and a new link from page 10 on. I
want to link page 9 to page 10 to keep continuity. However, the only thing
I'm allowed to link to is a blank page. Page 10 has data. If I insert a blank
page after page 9 as the new page 10 and link 9& new page 10, I still can't
link new page 10 to page 11 (which was old page 10) because it contains data
and this program won't let you link to a page that contains data. If I try to
cut the data out of page 11, the rest of the overflows into page 11, keeping
if from being blank and accepting the ...change calender view?
When I am viewing my calender, on the weekly view can I make it so Saturday
and Sunday get their own square, instead of them being split?
Not on the weekly view, only the monthly view.
"dpert11" <firstname.lastname@example.org> wrote in message
> When I am viewing my calender, on the weekly view can I make it so
> and Sunday get their own square, instead of them being split?
It depends on your version of Outlook!
Right-Click the Calendar view, and choose "Other Sett...Change rows to columns and vise versa
I have a worksheet that has a list of cities as row headers, and dates as
column headers with numeric values for data. It shows the # of new
construction permits issued in each metro area per month.
I need to select all the values for a city which are in a row, and paste
them into a column on the worksheet which will do the calculations I need. I
can't figure out how to change the source worksheet so that the cities are
columns and the dates are rows so I can do a simply copy/paste.
Is there a formula or something I can give to the first cell of the
destination column that will ...SendAs for "Exchange Domain Servers" and "Exchange Enterprise Servers" denied
I'm having problems with SMTP with all my exchange servers (4) under the
same organization. The Event IDs are 7010 and 7004.
I look them up and they are caused by the impossibility to authenticate
I've made focus on the article 843106
there, this paragraph call my attention:
If Integrated Windows Authentication is enabled, but the events persist, the
sending server in the 7004 event or in the 7010 event may lack or be denied
the SendAs right on the receiving server. If the sen...Unable to click on charts & unable to create any new charts Excel
Just started using Microsoft Excel 2007 and I seem to have done something
that means the chart option is unavailable. The chart section is now grey
and all charts I have created are 'locked' I cannot click on them anywhere.
I'm working on a project and need it finished by Monday.
Do you mean that if you click on a chart it does not get a border to show it
is activated and there are no range-finder borders around the data that
makes the chart?
This is a bit odd.
Have you tried a new workbook to see if the problem is with just this one?
My advice with all odd things is...