How to have formulas and formats auto copy to new inserted rows
I am looking for a way to have formulas and cell formats from preceeding rows
automatically entered into inserted rows. I have the Extend formats and
formulas option checked but it is not working?????
The following MSKB article explains how Auto Extend works, and some of
the reasons that it may not work:
XL2000: How Auto Extend List Behavior Works
> I am looking for a way to have formulas and cell formats from preceeding rows
> automatically entered into inserted rows. I have the Extend formats and
> formulas op...SMTP connector with outbound security enabled, enables authentication for all other connectors!!?!
*I have so far tested this on two Exchange Orgs. One being our live platform
and the other our test enviroment. Both are running Active Directory native
mode for 2003, with Exchange 2003 and Exchange SP1*.
Right this is my scenario:
I have two SMTP connectors, one is the default 'Internet' with a cost of 1
and address space of *. The other is called 'Admin users' has the a cost of
20 with the address space of * also. Our Front end exchange servers; let's
call them: 'EXFE1 and EXFE2' are the local bridgeheads for both connectors.
The Internet connector by de...Multiple copies of a forwarded email in Exchange
I have a challenge that is a thorn in side.
Background that may help:
I have seven Exchange servers in one 2003 Active Directory domain. These
servers are located in six ddifferent countries with one country also hosting
the front end server. I have contacts that have email addresses belonging to
other sytems e.g yahoo.com hotmail.com etc.
On to my Challenge:
I have setup forwarding for a number of accounts to their contacts (one of
them is my CEO). What happens is that if anyone who's mailbox is not hosted
on the same server as his mailbox, sends him email, more than on...HELP- Copy a Data Series to Other Graphs? #3
I'm using Excel 2002 and I've got a lot of XY (Scatter) graphs.
When I add a new data series to one graph, it is defined by 3 values
(Name, X Value and Y Value)
If I want to add this data series to 7 or 8 add'l graphs, I know that
I can copy/paste these 3 values to each of them.
Is there a simpler way to accomplish this?
...Enable automatic query refresh for all workbooks?
I know there's a way (according to a KB article on Office 2000 SR1), and in
Office XP I must have turned this off somehow, since my workbook didn't ask
me everytime if it should refresh or not, but I can't seem to find where
this checkbox is in Office 2003!
This checkbox has been removed in XL2003 for security reasons. You cannot
off the prompt using the XL interface. Modifying the following registry key
will give you the same effect:
0 = Prompt on all workbooks
1 = Do Not Prom...copy excel chats I dont stand
i want copy too file excel in my chats but i dont stand too program
I've got a fairly compex workbook with lots of named
ranges. I've been using and updating this WB for over a
year. All of a sudden, I now get the following message
every time I enter something in any field:
"The macros in this project are disabled. Please refer to
the online help or documentation of the host application
to determine how to enable macros."
I don't have any macros in this workbook.
I inadvertently checked the "Do not show me this message again" box,
but, as I like to know when I am being re-directed to or from a secure
site, I would like to re-enable it. Is is possible, please?
> I inadvertently checked the "Do not show me this message again" box,
> but, as I like to know when I am being re-directed to or from a secure
> site, I would like to re-enable it. Is is possible, please?
Have you looked at the settings for the security zone (probably the Internet
security zone) under which the unidentified web...transfer cell value from 1 sheet to another without copy/paste?
I need to enter a value 1 time and have it appear on additional sheets,
without copying and pasting to other sheets. Please help. I'm trying to
1. In Sheet1 cell A1 I type (for example):-
2. In Sheet2 cell A1 I type:-
This pulls in the word:-
- from Sheet1 cell A1.
There are other ways to do this.
If my comments have helped please hit Yes.
> I need to enter a value 1 time and have it appear on additional sheets,
> without copying and pasting to other...Copying data from Excel to Word
How can one copy the contents of cells in Excel to a Word document? Can you
use a cut-and-paste method?
Bob on Jeff's computer
"Jeff Wright" wrote:
> How can one copy the contents of cells in Excel to a Word document? Can you
> use a cut-and-paste method?
> Bob on Jeff's computer
...Problem with copy and paste
Seems to me I used to be able to copy and paste formulas
from one sheet/workbook to another. Now, whenever I copy
and paste from one sheet or workbook to another, the
worksheet cell references and formulas are lost.
What happened, and what can I do to fix it?
I can duplicate this if I have two instances of excel running--instead of one
instance and two workbooks open in that instance.
> Seems to me I used to be able to copy and paste formulas
> from one sheet/workbook to another. Now, whenever I copy
> and paste from one sh...Enabling Circular Logging
Hi all. I am performing backups of my exchange DB's over the internet
starting today. The company I am doing this with suggested enabling circular
logging on the Exchange server to avoid backing up unnesseccary data and to
svae over the wire bamdwidth. Can anyone explain to me what it is, and how
to enble it? I have Exchange 2003 standard server with SP1. Thanks!!!!
On Fri, 23 Dec 2005 08:51:01 -0800, "redrobit"
>Hi all. I am performing backups of my exchange DB's over the internet
>starting today. The compa...Determining if hibernation is enabled
I'm using SetSuspendState(TRUE, FALSE, FALSE) to put the pc in into
hibernation, which only works if hibernation is enabled.
How can I determine whether hibernation is enabled before calling, so I can
report as much to my users?
I'm working with VS2008, targetting XP and Vista.
IsPwrHibernateAllowed\ GetPwrCapabilities or
CallNtPowerInformation(Maybe it's better way)
"Steph" <firstname.lastname@example.org> д����Ϣ
> I'm using SetSuspendState(TRUE, FALSE, FALSE) to put...How do you link chart source data when you copy the chart?
I have rows and columns with data. I then chart the data which links the
source data to the specific cells with absolute references.
If I try and copy the rows et al with data and the chart and paste another
group of the same below it, the rows et al of data change the cell reference
automatically to the corresponding rows where I paste them [relative
references] but the chart keeps the original source data cell references from
where it was before.
How can I make the source data update automatically to reference the
location I paste it to so I don't have to change the source data ...How to copy column of email addresses and paste directly to addr
I want to copy a column from an excel sheet and paste it directly to the
address on an email.... How do I make the tthe semicolons appear?
What happened when you tried it? What e-mail program are you using?
A program like Outlook is smart enough to put the separator in by itself.
You just copy the column and paste it in the "To:" box.
Another option is to add the semi-colon in Excel. In another column, use:
Copy this down
Now copy and paste this column into the e-mail.
"Mrs. Mc" <Mrs. Mc@discussions.microsoft.com...Copy range with offset
I know how to copy a cell like this:
But how can I copy a range like this
My programming is self-taught and
my teacher was not very experienced. :-)
you can do it like
Kevin Smith :o)
"...set enable & disable of button (VC 6.0)
For VC 6.0 (MFC) :
How can I set the enable/disable state of that button ?
this is not going to work buddy ....... read a book .....
"Eitan M" <no_spam_please@nospam_please.com> wrote in message
> For VC 6.0 (MFC) :
> How can I set the enable/disable state of that button ?
> Thanks :)
//To Enable button...at run time ...IDB_MYBUTTON is ID of your
//To Disab...Enable/disable EDIT Menu's PASTE item according to clipboarb's format
Env: Windows2000, VC++6.00, MFC, .
I have a CView based application, which deals with BITMAP. Since application
can receive pasting operation coming from clipboard only for BITMAP format,
so I hope that ID_EDIT_PASTE item on "Edit" Menu and ID_EDIT_PASTE button
on toolbar can be enabled/disabled automatically according to the current
I know I can do that if I put IsClipboardFormatAvailable(CF_BITMAP) into
ON_UPDATE_COMMAND_UI(ID_EDIT_PASTE, OnUpdateEditPaste) as follows,
void CMainFrame::OnUpdateEditPaste(CCmdUI* pCmdUI)
pCmdUI->Enable( IsClipboardFormatAva...Copying multiple cells out of multiple worksheets at same time.
In Excel 2003 I was wondering if it is possible to copy multiple cells A1:O75
in multiple worksheets (sheet1, sheet2, sheet3, etc) and pasting them
Consecutively into one work sheet (all records)?
Thanks for the help.
Sheets("Sheet3").Range("A1:O75").Copy Sheets("S...copy of exchange 2000
I don't suppose microsoft is providing Exchange 2000 as a free download
anywhere are they??
Until we can afford to move up to SBS 2008 (hopefully later this year), I
want to trash our SBS 2000 (too many issues with it) and simply install a
win2k server with Exchange until we can move on. We are not using any of
the other SBS components any longer anyway...
If anyone knows where I might be able to get this from, I would be very
Why not look at BPOS? $10 per user a month it's a great inexpensive
solution. You may find you do not ne...RE-Enabled Acconts
OK, I have read dozens of messages about users not being able to access
their accounts if they were dis-abled then re-enabled. Nothing definitive
for an answer though.. Some have said WAIT.. My question is how long to
wait? I do know that if I re-boot the exchange server they get their access
back, so I am thinking it is a wait thing, but in one instance I had waited
1 hour... What is happening?
it can actually take up to 2 hours for the re-enabling to take effect...
Susan Conkey [MVP]
"Carl Hilton" <email@example.com> wrote in message
news:uib71bezGHA....Can you Mail-Enable/Disable Users by OU?
I was wondering if there was a way to mail-enable/disable users by OU or
group in Exchange 2000? I have one 2000 domain with 800 or so users, but I
only want 100 of them to have mailboxes. I know when you install Exchange
it asks you which users you want to mail-enable. But I was wondering if
there was a way to maintain this after the fact, say by saying everyone in a
particular OU has a mailbox. Also, are there any security measure that I
should take with regards to securing the Exchange server to the ~700 users
who don't have mailboxes and should have any access to the Exchange serve...MS Visual C++ 2005 Express and olectl.h...
I am trying to compile an OCX from an example provided with msvc2005 express
and I get:
..\ScanServ.odl(7) : fatal error C1083: Cannot open include file: 'olectl.h':
No such file or directory
Does this olectl.h come in some sort of SDK? Should it have been installed
with msvc2005 express?
Professional Disk Utilities
The express version comes with very limited capabilities; it wouldn't surprise me if the
OLE support was also omitted from the distribution (MFC isn't there, either)
On Tue, 19 Dec 2006 19:53:58 -0600, &...Copy 3 separate records from form into 1 row of table as new entry
I have a form that has 3 fields. 1 is the date (default = Date()), the second
is a value which is populated by a query into the form field, and the 3rd is
a number (1, 2 or 3 etc)
I would like to copy all those 3 records to a single new record in a table
of 4 columns (first being the "autonumber ID Key")
Preferably by double clicking the "second value" field in the form or by
button press on the form.
Private Sub Textfield_DblClick(Cancel As Integer) [or Private Sub
Dim strSQL As String
strSQL = "INSERT INTO MyTable(DateField, TextField, Num...Enable Override price
It is possible to enable the Override pricing function on the Order form. We
have noticed that the pricing of the order is greyed out if the order is
associated with a quote. It is possible to enable this functionality through
the use of Jscript using the OnLoad event.
You can't change the order form. But you can use Write-In products for
quote and order. then you can change the price of the product to
reflect the price chage for an order.
On Sep 19, 9:58 am, Mark Braithwaite