Prevent new pivot table items from being selected
I have a pivot table that contains accounts and reports sales by account.
Users selected the accounts they want to see and save their spreadsheet. When
new accounts are added to the accounts list, users do not want to see the new
accounts. They only want to see the accounts they selected from a previous
session when they refresh the pivot table.
Does anyone know how to prevent the new accounts from appearing in the pivot
Use another column: Include, with values of Yes or No, and include it in your pivot table, showing
Then when new data is added, enter ...Customization: disabling built in features
I would like to disable/remove some of the sections on the left hand
side of CRM. For example, on the home screen I would like to remove
the Invoices section since we don't use these. And on the Account
level I would like to remove the Notes and Contracts sections for the
Is this possible?
...Disabling / enabling entire menu and toolbar if child window open and has focus
I have an MFC app within which a user can choose to go to the
company's web site. If they select this from the menu, a CMDIChildWnd
is created containing a CHtmlView. I need to have it so when this
window is opened, all the menus are disabled and the toolbar is
disabled. Also, when the window loses / gets focus, the menus are
disabled / enabled respectively.
Is there an easy way of doing this? How might I go about it?
Thanks for your help!
You can't disable *all* the menu items typically, because you want File>Exit, Help>About,
other Help items, etc. en...Error when adding new user to CRM
I need to add 5 new users into CRM. When I complete the first form for the
user information such as Last name, First name, email address, etc, then
click the save button I receive an error page and the following message is
logged in the Application log.
MSCRM Platform Error Report:
Error: The statement has been terminated.
Error Message: The statement has been terminated.
Error Details: Details on this error have not been provided by the platform.
Source File: Not avail...SBS Exchange 2003: Create new user in AD but no exchange mailbox #3
I'm using SBS 2003. Exchange server is SP2.
When I create a new user using Active Directory, it prompts me about
creating a mail box. It says it's creating a mailbox, then it's done.
But no mailbox appears.
In fact, if I use the Exchange tasks wizard, I can create, delete, and
recreate the mailbox--all say successful without an error message. And
yet, no mailbox.
This is even after I reboot the PC and sent email to the address.
Any ideas what's going on?
> I'm using SBS 2003. Exchange server is SP2.
> When I create a new user ...Lookup Function in user form
I have a combo box (cboitem1) and a text box (txtprice1). I am using the code
below to have txtprice1 fill with the corresponding price the worksheet:
Private Sub Cboitem1_Change()
If cboItem1 <> "" Then
txtprice1.Value = Excel.WorksheetFunction.VLookup(cboItem1.Value,
Sheets("Pizzas").Range("A1:B65536"), 2, False)
It works perfectly when you enter an existing value in cboitem1. However if
'the user' accidently types a letter that is not the first letter of one of
the existing items VB debugging pops up with error &qu...Excel user information
I am interested in learning about who uses Excel and how they use it.
For example, what percentage of users have had formal training; how
many use VLookup, or how many build models from scratch. Does anyone
know of a source for such information?
No idea where you would get official stats, if indeed they even exist (Which
i doubt), but happy to give you my personal guess:-
Formal Training - Less than 1%
Use VLOOKUP - Less than 10%
Build Models - Depends on definition of what a model is. A couple of
cells of data with a formula could be construed as a model, so I...How can I turn of zooming so that users can't change size of work.
I have about 50 worksheets and the employees will be updating there own
worksheet. Some like to change the size of the worksheet by zooming out
which makes it hard for me to read. Is there a way that I can set the
zooming to a specific percent and then no let anybody change it?
I think I'd let the other users do whatever they found comfortable.
But I'd have a macro that changed the zoom to what I liked -- I could run that
whenever I wanted on whatever window is showing.
Dim myWindow As Window
Dim wks As...OL2007+Exchange: Sent items disappear if i move them to another folder...!
I'm seeing a very strange issue with my Outlook2007 (against
Sent items disappear if i move them to another folder...!
1. Send an email. Sent email gets saved under Outlook's default
2. Go to that SentItems folder, and move the mail to another folder
(let's say "Foobar") under your inbox.
3. Go to "Foobar", make sure mail is still there.
4. Let Outlook Sync up with Exchange server (or hit "Send and
5. You will notice that the mail disappears... !
I did a full text search in my ...Could Microsoft create a MSPOS user manual?
My customers are asking for one. Guess we were spoiled by RMS Store
Operations having one available after Microsoft updated the SMS Commerce
manuals. Makes me expect one for MSPOS even though most software no longer
has printed manuals.
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 t...Filtering data by custom fields in pivot tables from Visual Report
I have recently upgraded to MS Project 2007 and like the visual reporting
feature, except I really need to filter and group the resulting pivot table
in Excel by custom fields. For example, for task usage, I cannot filter my
pivot table to show only the tasks that have costs > $0, thus my table ends
up showing too many lines and a lot of 0's. I would also like to group by
department/ function which I put in a custom text field. How do I do this?
I saw related posts about saving the file as an Access database and then
creating the pivot table by connecting to the datab...Keeping Custom Properties When Forwarding or Replying to a Message #2
We have emails saved on the file system, that is kept track of by
another program. These emails have custom properties attached to
them. There is no custom form, just custom properties. These fields
were originally added using objPost.UserProperties.Add. We need it
so that when someone opens up one of these emails through the file
system, and then replies or fowards the message, these custom
properties are kept in the reply. This is so the external program can
track these emails. Is there a way this can be done? We could have
these emails opened up using an Outlook command line that i...User Template crashes Outlook2007
When I select a distribution template from "User Templates in File System"
Outlook crashes, sends error amessage, and reloads Outlook. Can't weem to
find the problem.
...Adding User Name to footer
I have spreadsheets that go out to a number of users, and they make various
changes and print out for themselves. The problems is that no-one knows
which version to pick up from a central printer. Can I add the user name to
the footer. I also have the path and file in the same area. I would like to
end up with :
User Name printed 'path/file' on 'date'
...How do you define a custom paper size in Excel? (i.e. 11x17)
How do you define a custom paper size in Excel? (i.e. 11x17)
Excel doesn't provide for custom paper sizes, but most any size appropriate
for Excel output is already provided _if_ the installed print driver supports
it. Go to File>Page SetUp--Page and open the list of sizes. If your installed
driver supports 11x17 it will be in the list (although it may be listed as
'Ledger' rather than by dimensions).
"Marcin Rembisz" wrote:
> How do you define a custom paper size in Excel? (i.e. 11x17)
...Transferring users from 1.2 to 3.0 upgrade
I am trying to upgrade a 25-user 1.2 installation to a 10-user 3.0 setup.
Only 7 of the 25 licenses are being used. When I run the setup, I receive
the following message:
There are not enough Microsoft CRM 3.0 licenses to include all the users
from Microsoft CRM 1.2 in the upgrade. Please add enough licenses to cover
all the active users or deactivate some users to match the number of licenses.
As I said there are only seven active users, so there shouldn't be a
problem. Does anyone know what I need to do to fix this problem?
I've never seen the error, but p...RMS User Question/Problem
I Downloaded and installed Microsoft Dynamics RMS, but when I first run it
(for the first time) it asks me user ID and password, but have not yet
and is the first time I run the program! (Or is it comes with some standard
user / default?)
User ID: 1
RMS Systems Inc.
"F.Misle" <F.Misle@discussions.microsoft.com> wrote in message
> I Downloaded and installed Microsoft Dynamics RMS, but when I first run it
> (for the first...Customized Task Views Have Disappeared (Take 2)
I was having an issue similar to this original post and followed the
given. It worked, but as I have worked with it I have found that it will
restore my customized Task views but not my customized Contact views. I can
change some of the Send and Receive setting and it will restore the Contact
views but not Task views. Somehow I am searching for a way to restore both
Task and Contact views. Any ideas?
Tia, Education and Documentation Specialist
Sorry, i posted this in the wrong discussion group. I have posted this
correctly and my question has been answered.
...CComboBox shows only one item at a time !
I am using CComboBox control and have tried both dropdown and dropddown list
styles. The problem is that I have several items in the combo box but
dropdown shows only 1 at a time (i.e. the arrows of v-scrollbar are stuck
together).. How do I remedy this ?
Thanks in advance.
"Ashish" <email@example.com> wrote in message
> Hi All,
> I am using CComboBox control and have tried both dropdown and dropddown
> styles. The problem is that I have several items in the combo box but
> dropdown sho...how to insert a item when ListCtrl is in "Icon" mode
I create a ListCtrl with "Icon" mode,but I found I can't
use the "InsertItem()" to insert a item in a specfied
position,the new item is always at the bottom of list,but
I want insert some items before a specified position,so
how to do it?
"pango" <firstname.lastname@example.org> skrev i en meddelelse
> I create a ListCtrl with "Icon" mode,but I found I can't
> use the "InsertItem()" to insert a item in a specfied
> position,the new item is always at the bottom of list,but
> I want i...retrieving deleted items
If a user deleted a bunch of emails before quitting can I retrieve those
without doing a restore? They aren't in her deleted items.
if you have DIR configured on that mailbox store, you can recover them by
selecting the deleted items folder, and selecting Tools, Recover deleted
items from the menu in Outlook...
Susan Conkey [MVP]
"Brandon Baker" <email@example.com> wrote in message
> If a user deleted a bunch of emails before quitting can I retrieve those
> without doing a restore? They aren'...Email automation of CRM per product according to sales cycle
Is there a way to automate Business Contact Manager for Outlook 2007 to email
a set of contact records every 10 days according to product interest and
according to where in the sales cycle that contact is?
I hope I’m able to put pen to paper here and explain this clearly…
The sales cycles is viewed as a Bell-Curve that begins at ‘Hello’ at the far
left of the curve to ‘Starting to think about a product and collecting
information’ as they climb up the curve to ‘Buying’ at the top of the curve
and ‘Follow-up’ items such as warranty items or asking for a reference at the
far right of the ...user name and password not being retained in WindowsMail
I have Vista 32bit sp2, IE8 and WindowsMail. I had this problem on my
XP/Outlook Express machine and found an answer, but can't find one for
WindowsMail. Please note that I have had this set-up for several months and
never incurred this problem. Even earlier today everything was working fine.
It looks as if I can send messages, but when I click on send/receive button
to receive messages I get a screen asking for my username and password. I
have it set to remember in 'tools' 'accounts', but it isn't remembering it.
Does anyone have a suggestion on how...e2k3 sp2: Unknown user name or bad password error
We have an exchange cluster with two nodes that runs exchange 2003 SP2 on
windows 2003 Sp1 ent. For security reasons recently I had to change the
password for the account under which I installed exchange - the account is
exchservice. Since then I get few of the following messages in the security
log on the server - any idea how can I stop this?
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
User: NT AUTHORITY\SYSTEM
Reason: Unknown user name or bad password
Us...Excel Menu Corruption
I tried to create an excel macro for the 'Sheet Hide' command from the menu.
All I did was corrupted this command on the menu. Now it always tries to hide
the sheet in the file I had open when I tried to create the macro.
Is there something less drastic than un-installing/re-installing office?
If you post your code we would have a better chance to help you.
Did you use the macro recorder when creating the macro?
Possibly you have the sheet name hard-coded in the code.
If you replace that hard-coded name with ActiveSheet perhaps would be better.