We've recently upgraded to 3.0 from 1.2, and now only the domain admin user
that performed the upgrade can see the "Settings" area in the nav bar. I
have the System Admin and System Customizer roles, and yet when I log in as
myself I do not see the Settings area. Doesn't seem to be permissions and
the sitemap.xml looks fine.
Anyone else seen this or can point me in the right direction?
Do you have the CRM for Outlook client running on your machine? There is a
"feature" of the app that prevents the settings from displaying when the
outl...Quirky recent file list #2
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
If/when you upgr...Automatic Calculation #2
Why is automatic calculation keeps running even though there is no
modification done in my spreadsheet?
What makes you think that excel is recalculating?
If it's because you see Calculate in the statusbar, it could be...
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
"Lucie Ch�nier" wrote:
> Why is automatic calculation keeps running even though there is no
> modification done in my spreadsheet?
> Lucie Ch�nier
Dave Peterso...Office:mac v.X #2
Operating System: Mac OS X 10.5 (Leopard)
I have subject version of Office. I know that there must be updates to this so I can bring this up to date but I can seem to find the ones I need to start the process. Can someone get me to the beginning? Thanks!!!
You can get the Office X 10.1.9 update here:
On 3/30/08 3:09 PM, in article email@example.comR9absDaxw,
"AWOLGolfer@officeformac.com" <AWOLGolfer@officeformac.com> wrote:
> Version: v.X
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
&g...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...Custom Report Grouping
I have created a database in Access 2003 and am trying to group by months but
the months set up in the database are based on a tradional month. We use
4,4,5 accounting months. How can I create a group to based on dates I set up?
On Fri, 22 Jan 2010 08:18:09 -0800, CARRIE <CARRIE@discussions.microsoft.com>
>I have created a database in Access 2003 and am trying to group by months but
>the months set up in the database are based on a tradional month. We use
>4,4,5 accounting months. How can I create a group to based on dates I set up?
I'd suggest se...subreport between each entry on the report
I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the entries
for the subreport show up in between those on the report. This is not what i
want. I want the subreport entries to show up below those of the main report.
How do i do this.
Put the subreport in the report footer.
Put the subreport in a group footer that is printed after your details
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
"...Dates in a form for filtering Report query
I have a form "Period" with two text boxes. One for startDate
and one for EndDate. I want to use that form to limit the query
for my Report by the dates. However, when I refer to the
Form it does not seem to understand it is a date? I use the following
statement in my query:
I also tried to convert it to a date like the following:
CDate(<=[Forms]![Perioder].[txtStartDate]))) but that did not work?
What should I do in order to the query to read the condition or dat...Exchange 2007 Evaluation version #2
Can I install it on 64 bit platform and run it as production?
On Fri, 23 Feb 2007 09:55:13 -0800, RG <RG@discussions.microsoft.com>
>Can I install it on 64 bit platform and run it as production?
There isn't an evaluation version as such.
You can install Exchange 2007 without a key for 120 days.
...Installing office 2000 disk 2 with publisher on upgraded windows x
I can not get disk 2 to install. It preloads then as files start to copy, it stalls then ends with error message. this is office2000 professional 2 cd set.
everything else works exept publisher and its components.
What is the error message?
MVP Microsoft [Publisher]
"cugolfn" <firstname.lastname@example.org> wrote in message
>I can not get disk 2 to install. It preloads then as files start to copy,
>it stalls then ends with error message. this is office2000 profess...New Check report security settings
I'm using Report Writer in GP v10. I want to duplicate the report "Check
with Stub on Top and Bottom - Graphical". I have tried to use the duplicate
button for the report but the report will not show up in the User Security
How can I make the duplicated report available to select users?
I would suspect you do not want to duplicate this report (since you cannot
really run it correctly) and instead you modify the actual report by
choosing the report and pressing "insert". You give security to the
modified version once you've modifie...Chart
Subject: Chart - Title Widths
Date: Tuesday, February 03, 2004 12:43 PM
Chart - Title Widths
Does anyone know how to find the width of a title/axis title?
...Upgrading from Exchange 2000 Standard to Enterprise Cal ? #2
I know the upgrade process from exchange 2000 standard to enterprise
seems pretty straight forward. However, I have a cal question. Are my
standard cals still good with this upgrade. Say I have right now
standard 2000 with 30 cals. If I upgrade to Exchange 2000 Enterprise
with 25 cals to pass the 16mb limitation.
Would I then only have the 25 cals or 55 total cals?
I'm hoping someone can help me with this.
I have Exchange2k3 SP2 running on a Win2k3 server. Our Exchange Admin is
out on medical leave so I am resuming his responsibilities.
My problem is I cannot access some of the storage groups using exchange
system manager. We have 4 mailbox stores and I get an error trying to access
3 of them. The error is "An unknown error has occurred. ID no: 80040d1b
Exchange System Manager". What is really puzzling is if I click on a storage
group a second time, I don't get the error but the storage group shows up as
empty. I have thi...how to divide a numbers in a table of data by 1,000, all at once
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".
In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
Or, to go at it from another angle, how do I divide each # by 1,000?
The ROUND feature requires that I create a new table. Not exactly what I'm
Enter 1000 in an unused cell.
My friend forwarded the following link. I getting free CRM magazine
without any hidden cost and spam. Link is
CRM Magazine is written for whom responsible for moving the enterprise
toward a customer-focused approach.
Forward this link to your friends.
Let's hope the writing & editing is better than what's in this spam msg
promoting the mag.
"CRM" <email@example.com> wrote in message
My friend forwarded the ...#Error Message
I have created a calculation to count the number of people and placed it in
the Name Footer: =count([EyNumber]) and called the unbound box, CountNames.
When there are no results it returns the #Error message. How can I remove
this error message and display a message like, "No Data", or display the true
results of a count? I have tried using the IsError function but can't seem to
get it to work.
=IIf(IsError([EyNumber]), "No Data", Count([EyNumber])
>I have created a calculatio...Outlook should be able to email MS CRM advanced find queries (grou
The only way to e-mail a group in MS-CRM is to use the Quick Campaign
function. The Quick Campaign has several disadvantages:
- attachments for emails are not possible
- this takes at least about 10 more clicks compared to sending a standard
- the quick campaign doesn't have the look-and-feel of Outlook to which
users are accustomed to
Therefore it would be great if you could select the emailaddresses from
groups retrieved from MS CRM into the TO:, CC: or BCC: field in a standard
Outlook email message. Actually you would make the advanced find queries
available to sel...Re: Counting Occurrences with 2 columns
Suppose your data is in Sheet1 in A2:C6
> Red 4 Read
> Blue 5 Not Read
> Green 6 Read
> Yellow 2 Read
> Red 3 Not Read
Try this set-up in a new sheet, say Sheet2
List down in A2:A5 the names: Red, Blue, Green, Yellow
Put across in B2:C2 the phrases: Read, Not Read
Put in B2:
Copy B2 across to C2, then copy down to C5
[Note that the ranges used in SUMPRODUCT have to be similar
and you can't use entire columns e.g.: A:A, B:B, C:C]...Question Regarding Excel 2007 Formatting Corruption #2
I am having a problem with Excel 2007 files losing all formatting
(merged cells, colors, borders, and data formatting (99% turns into
0.99)) when I open a file on our office server make edits and then
save the new file on the server. Each sheet usually has a mix of
locked and unlocked cells and I unprotect the sheet to make edits.
Also, something is fundamentally changed with the file as its size
doubles or triples. If I reopen the corrupted file and redo any of
the formatting and try to save it none of the new formatting is
retained either. Has anyone else ever experienced a pr...How to obtain the name of ODBC definition used in a spreadsheet? #2
How do I get the name of the ODBC def used in my spreadsheet?
How do I migrate my spreadsheet (with the ODBC connection) to a different
computer and change the name of the ODBC def to a new name, available on the
I am working on an application that has more than a dozen of data files.
When the application closes, it uses IStorage/IStream to move them into one
file (IStorage), from the user's point of view. When the application is
started next time, these data files are extracted from the one file. By
extraction, I mean to programmatically read from IStreams and then write to
new, separate data files. The reading and writing are done chunks by
chunks. The whole process works fast only if all the data files are small.
The main issue to me is not disk memory space, but the speed. ...Mailbox Cleanup Agent #2
We need to delete a few mailboxes on our Exchange 2003 Server.
We've deleted the AD acounts but when we go into system nanager and try
to choose purge, it's greyed out. Our retention period for deleted
mailboxes is 30 days. Can we run the cleanup agent now on the live
system to speed up the deletion of the mailboxes? Or is it not
On 3 May 2006 06:37:15 -0700, "Jim C" <firstname.lastname@example.org> wrote:
>We need to delete a few mailboxes on our Exchange 2003 Server.
>We've deleted the AD acounts but when we g...svhost.exe: A CRM-related File?
McAfee VirusScan has suddenly notified me that it detected
a "potentially unwanted file" on the machine that I am
using to host an ActionPack version of Microsoft CRM. This
is an SBS installation, with everything running on one
test machine. Here is the warning from McAfee:
Potential Unwanted Program Detected!
The file C:\WINNT\System32\svhost.exe is a Potentially
Unwanted Program (ServU-Daemon)
When I try to move the file to the desktop, I am alerted
that it is in use and cannot be moved (no surprise, huh?).
The interesting thin...