SUMPRODUCT reference changes!!! Not what I want...
I am using SUMPRODUCT to sum a column on another worksheet. My formula looks
The # of rows on worksheet DATA changes perodically. When I delete the rows
in DATA and paste in new rows the "to" reference changes to the same as the
What can I do to keep my "to" reference at...CRM 3.0 if I change account owner, CRM change all the activitys ow
CRM 3.0, si cambio el propietario de una cuenta se cambian los propietarios
de las actividades asociadas a esa cuenta ¿porque?
CRM 3.0 if I change account owner, CRM change all the activitys owners
linked with this account ¿why?, the same if I change Incident owner.
...Insert Word document into email body message
Would like to know if someone knows of a vba code whereby I can insert a
Word document into to body of new message while still retaining all the Word
document formatting code?
...How do I hide the list of recent word documents?
When I write word documets, anyone can see what I wrote by looking at my list
of recent documents; can that list be hide or protected?
Setup Windows profiles for the users of your PC and don't let anyone else
have access to your profile.
If this is a company machine then while you may have sufficient access to
hide the the recent files list, you are unlikely to have sufficient access
to remove the footprint of your activity from the registry and the filing
You have two practical possibilities
1. Don't write stuff on a publically accessible PC that you...List box questions
I have a table that contains document metadata for a set of reference
I have a form that displays the metadata in separate fields. On the form I
have a list box that only lists the document titles. When the user clicks
on a title,
the detailed document metadata gets displayed on the form. That all works
1. When the form first opens, the document details that are displayed are
NOT from the first document (sorted by title, even though I have set it to
2. The list box is nicely ordered by title, as desired, but there is not
select...save publisher document to word
I need to save a Newsletter that is created in Publisher, to a word document.
I know that you can copy and paste and that should work fine, but when I
paste it into the word document, everything is in the wrong place and part of
it is gone because it prints at the right side of the page and you can't get
to it. Does anyone have any idea what would be causing this and how I can
Word and Publisher are not exactly compatible. You can copy/paste and then
adjust. Have you thought about converting the newsletter to a PDF?
What version Publisher are you using? T...Import Specs Changed "Magically" in Midst of Loading Sequence
I am completely confused and FRUSTRATED with this latest problem with Access
We are using Access 2007 running against 2000-2003 format (.mdb). Until
yesterday, this database which has functioned famously for a long time.
Never a problem with this "automated" load process, to collect 4 text files
from a network location and load them to this database elsewhere on the
network. What is puzzling, is that the Import Specification works for the
1st two files then MAGICALLY the spec changed from delimited to fixed width
during the processing! Anyone have a clue ho...can not find graphic convert for Publisher 2000
- some of these convereters maybe missing. If so where do I find new grahic
converters Although reinstalled Publisher 2000 will not draw up photos.
States that need Graphic Converter. No sign of them on MS site. Have
cleared PC of all old publisher but still no luck in using it again. It
still states can not convert picture
Hi Martyn Long (Martyn Long@discussions.microsoft.com),
in the newsgroups
|| - some of these convereters maybe missing. If so where do I find
|| new grahic converters Although reinstalled Publisher 2000 will not
|| draw up photos. States ...Webmail password changing option
wasn't there a way to change your password threw OWA? Maybe i am wrong but i
thought like exchange 2000 you could change your password threw owa under the
options button. I am looking at 2003 and do not see that options. I didn't
set this up, so am i just missing something?
> wasn't there a way to change your password threw OWA? Maybe i am wrong but i
> thought like exchange 2000 you could change your password threw owa under the
> options button. I am looking at 2...Null Object Error. Driving me crazy. Please, help me out ...
I am having a problem with a C# class for hours and I cannot find the
Basically a Web Application works fine but when Google Verify, Spider,
W3C validation try to access the page a 500 error is generated.
I was able to identify where the error is and created a simple web
Note: If you access it directly everything works fine.
I then used Rex Swain's HTTP Viewer which shows what error occurs when
the page is accessed:
And displays the stack ...
Just submit with http://...microsoft word 2000 problem
I'm having trouble opening anything up in microsoft word
2000 it is taking to long and freezing. we had a virus
but that was taken care of, but this problem with
microsoft still presists.
...Changing whats on the z report
We have c-stores and i want to make it so the program does the math for us on
the lotto. We do a count on lottery after every shift so at the end of the
shift when we punch in the amount of cash and all i would like to be able to
put in how much lottery tickets were sold and have the program subtract what
was rung up and give me a plus or minus on it the differnce. Can i make the z
report do that? I think this would work as well with gasoline sales as well
or anything that you count before shift or after shift. thanks in advance for
I suggest to buy another cash drawer ins...How can you change the color of the selected range?
How do you change the default colour that excel applies to a selected range
of cells? I do not want to permenantly highlight them (fill them) but I do
want the selected range to be more obvious?
Very odd request?
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
...Error 4.4.7 exchange 2000
I have a strange situation here... I'm having problems sending outbound
email to users at a specific domain name - the messages are delayed and
the sending user gets a message stating so. Eventually, the message is
returned to the sender stating that it couldn't be sent. I am running
Exchange 2000 with all the service packs and hotfixes. The destination
server is Exchange 2003 and I'm assuming that they're running the
latest SPs on it too...
I have read many different MS articles and error references, however,
as I mentioned above, I have a strange situation.
...How to change investment "Category" ??
I have M-2004, and now I remember why I hate it so much. After the first
few frustrating weeks I abandoned trying to do invoicing and
bookkeeping, and have only used it for investment tracking since.
And it is barely able to do that.
I've tried and clicked and poked and prodded, but I cannot figure out
how to edit the "Category" of any particular fund that I hold. Right
click, left click, tools/options, "see details," nothing nothing.
By "category" do you mean asset allocation? It is what Money thinks it is.
You can't fix/improve it...Two links changed on my site
I have no control of my second site anymore (rondebruin.com)
I can't reach my hosting company on this moment (vacation I think)
I only use this site for testing but there where two pages on it that I have now add to my NL site
Disable command bars and controls
Analysis ToolPak Translator 7.0
Regards Ron De Bruin
I think I've always used .nl.
But do you really have two separate and distinct sites or does the .com site
(usually) redirect to the .nl site?
(From ...Excel: Can't save changes to print number of copies setting
I inherited an Excel workbook that has the number of copies to print set to
10. I change it to 1, then save the file, but it always reverts back to ten.
...change the "from" email address
Can I change the "From" address when sending in Outlook?
If sending a message to a website and don't want them to
have my primary email address, can I send an "alias"
address so I don't get spam from them?
You can change the From address in the properties of your email account, but
it won't accomplish what you think it will.
Your email address is contained in the header of the email and will be just
<firstname.lastname@example.org> wrote in message
news:1c0201c4ad49$65855030$7d02280a@p...Saving no changes
When I open excel, even if I make no changes, it will ask if I want to save
the changes when I close it. Why does this happen and how do I correct it?
Thanks In Advance
You likely have some volatile functions within your workbook, eg =NOW(),
=TODAY(), =RAND() etc. These update every time you open the workbook and so
cause Excel to view change as having been made, hence the message.
Longer list from Norman:-
Ken....................... Microsoft MVP - Excel
...2007 DST Fix for Exchange 2000 Enterprise
I'll be running Exchange 2000 Enterprise into the middle of 2007 when we
plan to migrate to either Exchange 2003 or 2007.
My question is how can I obtain a 2007 DST patch for my Exchange 2000
server? I understand that CDO will be affected.We use both OWA and
Blackberry Enterprise server which both leverage CDO.
I have called MS tech support, and plunked down $250 to be told that I MAY
be able to get a fix if I subscribe to Premier support for my Exchange 2000
system. They were also quick to tell me Exchange 2000 is in extended support
phase. As such no DST patch is planned ...PowerPoint can't locate Microsoft Office Word
I am using MS-Office 2007. All components are registered. When I try to
publish my PPT to MS-Word I get the message "PowerPoint can't locate
Microsoft Office Word. Make sure that Microsoft Office Word is properly
installed on your computer."
How can I correct this problem?
Have you tried running the Microsoft Diagnostics to see if does not fix the
MS MVP - PowerPoint
"Jerry B" <JerryB@discussions.microsoft.com> wrote in message
> I am using MS-Of...Count change in state
I have a load of values in a spreadsheet which are either true or false.
I need to count how many times it changes from false to true, bearing in
mind several true values may follow each other - before returning to false.
the result would be 3 - ie it changed from FALSE to TRUE 3 times.
Thanks in advance.
I count 2 in your test data.
And I counted 2 using this formula (with your data in A1:A9:
Adjust the ranges to match--but you can't use whole columns (except in xl2007).
=sumpro...How to change the title of a CPropertyPage
I want to change the title of a CPropertyPage. I had overrided the
OnInitDialog() of my CPropertyPage and used the SetWindowText() to
change the its title. However, it does not work.
Does anyone know how to change the title of CPropertyPage? Thanks.
> I want to change the title of a CPropertyPage. I had overrided the
> OnInitDialog() of my CPropertyPage and used the SetWindowText() to
> change the its title. However, it does not work.
> Does anyone know how to change the title of CPropertyPage? Thanks.
Do you mean CPr...Find records that have been changed/deleted by disgruntled employe
Assuming we have a employee who is unhappy how do we find any records he may
have changed in the last two months and how do we restored those individuals
records so that they have the correct information. We would assign some
clients to multiple employees.
unless you have some after-market auditing software, you're not going to be
able to know everything the employee has done. you can use the 'modified
on' and 'modified by' attributes on every CRM entity to query (using
advanced find) where the user was the last one to modify the record after a
Even ...default # print copies changed
My Excel 2002 default number of copies has somehow changed
to two (2) - whether I click on the printer icon, use CTRL-
P or, go to FILE and choose PRINT - the default is set to
two copies. Does anyone know how to return this setting
to one (1) copy?
I was able to duplicate this problem by changing the
When you open the PRINT > FILE dialog box, choose
PROPERTIES just to the right of the box where you select a
printer. I'll bet you will find that your printer property
is set to 2 copies. Reset it to ! and the problem should