Creating PivotTable in Excel2007
How do you create a Pivot Table in Compatibility Mode in Excel 2007. The
PivotTable need to be refreshed in Excel 2003.
...IE8 and norton 360 tool bar
norton tool bar inop since i upgraded to IE8, norton asks if IE8 is 32 or 64
bit, i dont know
google do i have 32-bit or 64-bit internet explorer
Errare humanum est
> norton tool bar inop since i upgraded to IE8, norton asks if IE8 is 32 or 64
> bit, i dont know
Contact Norton Support.
> norton tool bar inop since i upgraded to IE8, norton asks if IE8 is 32 or
> bit, i dont know
Forget the Google suggestion above (for once). Just see this KB article; it
provides exactly the answer to your question:
h...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 ...Missing Title Bar
I don't know what I did. Now the title bar of my document
is missing, and the document is in a fixed position below
my toolbar. I cannot minimize or expand my document.
Thanks in advance, you rock!
Sounds to me like you maximized the spreadsheet. If this is the case
look in the upper left corner of excel. You should see a Min, Norma
and Max buttons for excel. Below these, you should see another set o
Min, Normal and Max buttons which is for the spreadsheet. Click th
middle one (normal) to return to the original way of viewing.
Message posted from http://www.Exce...FRx scroll bars
It seems that FRx scroll bars 'freeze' sometime when my client is using
drilldown viewer. They have to log out of it and go back in to get them
active again. They are on FRx 6.7.9111. Is that an issue that you have seen
Yes, it seems to be a bug in the latest service pack. It didn't
happen prior to applying the SP.
Tell them to not to use the arrow buttons to scroll - either drag the
little scroll button or click in the scroll bar to scroll up and
down. That should prevent the scroll bar freeze.
Another bug in the latest SP - exporting to Excel doesn...upgrade from 1.2 to 2.0 #2
I am upgrading from version 1.2 to version 2.0 and I have a couple of
questions about the upgrade.
1) Is there any step by step or relevant documentation on this upgrade?
2) do I need to upgrade to v1.3 before going directly to 2.0?
3) can I install 2.0 on a box that doesn't have any RMS loaded already?
4) What is the most difficult part of the upgrade (hardware,settings,etc)?
Thanks for your time.
...copying text on sheet 1 to corresponding cells on sheets 2 to 5
I want the text entered in A8 on sheet 1(named Productivity) to automatically
transfer to A8 on sheets 2 thru 5. I used the simple formula
=Productivity!a8 in the corresponding cells but when there is no data in
Productivity A8 I get a 0 in the corresponding cells. I would like the
corresponding cells to remain blank if there is not text in Productivity A8.
I am really new to excel, like only used it two weeks! Is there a simple fix
newbie at large!
A formula will always return 0 if it's refering to an empty cell. This
formula will let the cell look empty if no...problems sending email with crm 1.2
Anybody please help me, i installed the MS CRM 1.2 like 2 months ago, it was
working just fine, today my boss wanted to send an email with crm and the
following message appear
"An error has occurred. For more information contact your system
administrator.",every user when is trying to send an email the same message
appear even with the administrator account.
WHAT TO DO PLEASE HELP
Did you install the CRM Exchange E-Mail router?
> Anybody please help me, i installed the MS CRM 1.2 like 2 months ago, it was
> working just fine, today my boss wan...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...Viewing xml created in .Net in a ASP form VB6
I have been trying to create an xml document in VB.Net for displaying
on an existing page written in ASP.
im having a type mismatch error in my code. When i view my XML i have
the following included in the <binary> node.
dt:dt="bin.base64">DATA HERE </Binary
My issue is how do i set the datatype of the the node using dotnet so
that i can replicate the same node structure and use my existing ASP
thanks in advance
...downloaded service pack 1 and now Microsoft Excel isn't working ri
When I got to the icon for the save option I get this message
"The file ' .xls' may have been changed by another user since you last saved
it. In that case, what do you want to do?"
*save a copy
this dialoge box is getting annoying, If I choose save a copy I have copy's
of my files all over the place, if I overwrite then it does just that. But
why do I have to do this everytime I open a file? I have looked everywhere
and can't find my answer. Please remember that I just downloaded the Windows
update service pack 1 and I believe that this i...How do you replace old data with new data without creating a new .
I have existing pivot tables and I want to replace the data source worksheet
with new data and the pivot tables update with the new information. I have
replace the data source but the pivot tables didn't update.
Hit the "Refresh Data" in the pivot table toolbar (looks like an exclamation
> I have existing pivot tables and I want to replace the data source worksheet
> with new data and the pivot tables update with the new information. I have
> replace the data source but the pivot tables didn't update.
So...Combining Pivot Tables
I have a data set of around 100,000 rows which I have imported into
excel in two sheets (~50,000 rows each).
The data is not in a format that excel can easily parse into a pivot
table directly from the source - it requires some formulae in excel to
be able to use a pivot table.
I have used a pivot table on each of those sheets to summarise the
data, and that works fine.
However, I would like to be able to get a single summary pivot table
from the two sheets (or from the two pivot tables).
Is that possible, and if so, how do I go about it?
"Alan" <...Creating a form or template
We scanned in an image of a post it note that has graphics
on it. It is a jpg file. Can we somehow make this jpg
file a form or template in Outlook? Ideally, we want to
pull up a form that looks like the image of a post it note
with the graphics in tact and be able to compose a message
on the email post it note. How do you accomplish this?
...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...CRM 1.2 07-27-06
My company wants to move away from CRM 1.2. They want to keep using the CRM
database because of the volume of data that resides their. Can they still use
the CRM database after the CRM 1.2 license expires?
Yes. You own the data. As for the "license", it doesn't really expire.
You have the rights to use the software, but you have a support contract
which will expire. Once that expires, you will not be able to get free
upgrade tot he software, but you can still continue to use the app.
MVP - Microsoft CRM
"Hammer" <Hammer@discussions.microso...[ANN] Office 2008 for Mac 12.2.1 available now
Office 2008 for Mac 12.2.1 update is live! Fixes bug where Open XML files
couldn't be opened. Only English version is available now. Other languages
soon. It is also not available via the Microsoft AutoUpdater (MAU) at this
time. Download from Mactopia.
Steps for a good install:
Quit all Microsoft applications including the hidden ones.
Easy way, Log out of your User under the Apple menu
Log in holding down the Shift key to disable all startup items
Install the updater you downloaded from Mactopia
Good tip f...is it possible to host multiple CRM databases on 1 SQL server?
Is it possible to host two separate (on premise) CRM server databases
on one SQL server?
I am trying to achieve the above scenario, but there can only be one
MSCRM_config database on any one instance of the SQL server.
The Implementation guide isn't too clear about what to do in this
- Can two CRM databases share the same MSCRM_config file?
- Do I need to install another instance of SQL server for the second
Or is there another solution?
Depends on your CRM installation. If you are running the Enterprise version,
then you can add a new org...Insufficient Permissions to Create Tasks
Exchange 5.5, Windows 2000, Outlook 2000. I have a user
who is trying to create tasks and he gets a message that
says that he does not have permission to do this. He can
edit tasks and delete tasks, but not create them. We've
run the repair utility, reinstalled, thought that it had
to do with the PALM software and removed that, and there
has been no change. Any help would be much appreciated!
...Fonts do not print in colur used when document created.
When I create a document in either Word ot Publisher the text is not always
printed in the colour selected. This problem seems particular to Red & Blue.
can any one help please.
Have you tried some maintenance on your printer?
Are you saving as a PDF? This problem has been reported using Microsoft's
save as add-in.
"Peter Piper" <PeterPiper@discussions.microsoft.com> wrote in message
> When I create a document in either Word ot Publisher t...CRM_URL Issues $1
Ok you really won't get a $1 for this but I appreciate any help. :)
I have found a few postings on using the CRM_URL. I am using CRM 3.0
and developing the report in VS22005 linked to the production
database. One that was some help is at the bottom of this page. My
report has 11 data sources only one of tthose being used for the main
table that I want to link the Opportunity CRM_URL with. The others are
either for filter drop downs.
I am not able to get this to work and I believe that I am linked
directly to the database as I set up a direct connection to the
database and although there ...Stack Bar Charts
I have yearly information that I would like to graph in a stacked bar chart.
I have years 2005 to present
Two companies I am comparing with two variables for each company each year.
I would like to have the stack bar chart by year reflect the stack of Co A
vs Co B on variable 1 + 2.
Any help would be appreciated.
You want a clustered-stacked chart:
Peltier Technical Services, Inc.
> ...How does MSCRM 1.2 handle conflicts in synchronization w/ Outlook?
I know that MSCRM in v1.0 is "last in wins". Is this the same with v1.2?
> I know that MSCRM in v1.0 is "last in wins". Is this the same with
MCSD.NET, MCDBA, MCSE, MCT
MCP CRM Application/Installation/Customization
...turning off formula bar
I can't remember or find how to turn off the formula bar in Excel 2003? Can
someone help please. This is the bar that displays cell contents up top.
Tools>Options>View tab, uncheck Formula bar
Microsoft MVP - Excel
"Randy Starkey" <randy.starkeyNOSPAM@NOSPAMvictorychurch.com> wrote in message news:email@example.com...
|I can't remember or find how to turn off the formula bar in Excel 2003? Can
| someone help please. This is the bar that displays cell contents up top.
| --...Choosing FROM when creating an e-mail
I have several e-mail accounts. When creating a new e-
mail message sometimes I like the option of choosing a
different e-mail account the new e-mail is 'from' rather
than the default account.
This function is possible in Outlook Express via a drop
down list in the 'FROM' field when creating an e-mail,
but Outlook doesn't even have a 'FROM' field and uses the
default e-mail address as the return address.
Please advise if this is possible in Outlook. Thanks.
(PS I'm using Outlook 2000)
Outlook 2000 Corporate or Workgroup mode (check Help->About) doe...