Page 434 of 755« First...102030...432433434435436...440450460...Last »

How to use GrooveClean.exe to delete Groove data

This article describes how to use GrooveClean.exe (GrooveClean) to delete Groove data.

GrooveClean is included in Microsoft Office Groove 2007, in Groove Virtual Office, and in Groove Workspace. If you run GrooveClean without options, GrooveClean deletes the following temporary data:
  • The transmit and receive buffer files
  • The cached diagnostic information
  • All associated log files

You may lose some transient information by deleting the buffer files. In particular, instant messages that have not yet been sent or that have been received but not processed will be lost. However, the dynamics manager in Groove should recover workspace changes that you made, even if the changes have not yet been transmitted. Therefore, running GrooveClean without options is generally safe.

Note For information on how to delete this data in Microsoft SharePoint Workspace 2010, click the following article number to view the article in the Microsoft Knowledge Base:

982279
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;982279)
How to delete temporary and permenant data in SharePoint Workspace 2010

To run GrooveClean without options, follow these steps:

  1. Exit Groove.
  2. After Groove shuts down, type one of the following commands at a command prompt, and then press ENTER:

Sometimes, you may have to delete permanent data and temporary data. To do this, run GrooveClean with the -all option. When you run GrooveClean with the -all option, all Groove accounts, workspaces, and temporary data are deleted.

Caution The GrooveClean -all command deletes all Groove data. In versions of Groove that are earlier than Groove 2007, this includes the Groove data of other Microsoft Windows users who are on the same computer. After you run the GrooveClean -all command, you will not be able to use Groove until you create a new account or import a previously saved account.

If you create a new account, it will not have the same identity and will not belong to any workspaces, even if you use all the same information when you create the account. If you create a new account, you must distribute your new identity to all your Groove contacts and be reinvited to workspaces.

To delete all Groove data in Groove 2007, follow these steps:

  1. On the Files menu, click Exit.
  2. Click Start, click Run, and then type the following command:

    “C:Program FilesMicrosoft OfficeOFFICE12GrooveClean.exe” -all

  3. Click OK.

To delete all Groove data in Groove Virtual Office or an earlier version of Groove, use one of the following methods.

The Run method

  1. On the Files menu, click Exit Groove.
  2. Click Start, click Run, type the following command, and then click OK:

    “C:Program FilesGroove NetworksGrooveBinGrooveClean.exe” -all

The command-line method

Note This method is required if you are using a computer that is running Microsoft Windows Millennium Edition.

  1. On the Files menu, click Exit Groove.
  2. Open a Command Prompt window.
  3. Type cd progra~1groove~1groovebin, and then press ENTER.
  4. Type GrooveClean -all, and then press ENTER.

See the original article here:
How to use GrooveClean.exe to delete Groove data

You receive a "Too many different cell formats" error message in Excel

In Microsoft Excel 2003, when you format a cell or a range of cells, you may receive the following error message: 

Too many different cell formats.

Excel encountered an error and had to remove some formatting to avoid corrupting the workbook.

In Microsoft Excel 2007/2010 files may produce the following error message;

Excel found unreadable content in the file

Other scenarios that as associated with styles are:

1. When opening a file all formatting is stripped out.

2. File size grows after copying and pasting between workbooks

3. Inability to paste:

Microsoft Excel displays

“Microsoft Excel can’t paste data”

 

All menu option for “Paste” or Ctrl-V keyboard shortcut are ignored and produce no results although clipboard is not empty.

This problem occurs when the workbook contains more than approximately 4,000 different combinations of cell formats in Excel 2003 or 64,000 in Excel 2007 and higher. A combination is defined as a unique set of formatting elements that are applied to a cell. A combination includes all font formatting (for example: typeface, font size, italic, bold, and underline), borders (for example: location, weight, and color), cell patterns, number formatting, alignment, and cell protection.

NOTE: If two or more cells share exactly the same formatting, they use one formatting combination. However, if there are any differences in formatting between the cells, each cell uses a different combination.

In Excel style counts may increase when copying between workbooks because custom styles are copied.

A workbook that has more than 4,000 styles may open in Excel 2007 and higher (because of the increased limitation for formatting) but result in an error in Excel 2003.

1. To prevent styles from built in styles from being duplicated when copied make sure you have the latest updates for Excel installed from Windows Update. 

2. The following KB articles allow disabling copying custom styles between workbooks in one instance of Excel. Install and add registry key in the following article. 

Unused styles are copied from one workbook to another workbook in Excel 2007

3. To cleanup workbooks that already have numerous styles, run one of the following:

Excel formats (xlsx, xlsm)

XLStyesTool
(http://sergeig888.wordpress.com/2011/03/21/net4-0-version-of-the-xlstylestool-is-now-available/)

Older Excel formats (xls)

4. Simplifying the formatting in your workbooks. For example, the following are suggestions for simplifying formatting: NOTE: After you simplify or standardize the formatting in the workbook, save, close, and then reopen the workbook before you apply additional cell formatting.

In most cases, the limit of approximately 4,000 different formatting
combinations for a single workbook is sufficient. This problem is likely
to occur only when the workbook contains a large number of worksheets that
use different formatting, or when a large number of cells are all
formatted differently.

Read the article:
You receive a "Too many different cell formats" error message in Excel

Some messages are rejected when you try to use Exchange Online servers as an SMTP relay for on-premises business applications and network hardware devices

Custom business applications and network hardware devices such as printers or faxes frequently use Simple Mail Transfer Protocol (SMTP) relay servers to send email notifications. When you try to use Microsoft Exchange Online servers as an SMTP relay for on-premises business applications and network hardware devices, messages that are destined for mailboxes that are not in the Exchange Online environment are rejected. Additionally, you receive the following error message:

#5.7.1 smtp;554 5.7.1 <clientemailaddress>: Relay access denied

This behavior is by design. If the delivery IP address that tries to relay through Microsoft Forefront Online Protection for Exchange (FOPE) is not in the Outbound Mail Server IP Addresses list for the domain or organization, a “Relay access denied” error message is returned.

In Exchange Online subscriptions, the Outbound Mail Server IP Addresses field in the FOPE Administration Center is deliberately disabled because Exchange Online subscriptions do not include SMTP relay services for mail that is sent from the on-premises environment to Internet email addresses. 

For a full, cloud-based SMTP relay experience, purchase a FOPE stand-alone subscription to enable SMTP relay through Microsoft Online Services. For more information about FOPE, visit the following Microsoft website:
To work around this limitation, use one of the following methods, as appropriate for your situation.

Method 1: Relay only to Exchange Online addresses

Exchange Online receives the SMTP relay that is directed to Exchange Online recipients. Because of this, you can program on-premises business applications and network hardware devices to send SMTP mail to Exchange Online recipients.

Note This is more common for programmed warning messages or for reporting email messages. With general-use SMTP applications such as scan-to-email, it is much more difficult to control or to predict the required recipient email address.

  1. Make sure that on-premises applications and devices are programmed to send only to recipient email addresses that have a domain suffix that is already implemented in the Exchange Online service. The steps to configure this vary from application to application.
  2. Direct SMTP traffic from on-premises applications and devices to use the MX record value that is associated with the Exchange Online tenant service as a SMTP smart host.
  3. Make sure that the appropriate recipient object or SMTP address is represented in Exchange Online as a recipient. For more information about how to do this, visit one of the following Microsoft websites:

Method 2: Implement an on-premises SMTP relay service

If full-featured SMTP relay functionality is required and you do not want a FOPE stand-alone subscription, you should implement an on-premises SMTP mail relay server. This functionality can be implemented on any number of different mail servers, products, and versions, based on the business need. For an example of how to do this with Internet Information Services (IIS), click the following article number to view the article in the Microsoft Knowledge Base:

230235 

(http://support.microsoft.com/kb/230235/
)
 XCON: How to configure the IIS SMTP service to relay SMTP mail

For an example of how to configure an on-premises SMTP relay server to send mail as an Exchange Online recipient, click the following article number to view the article in the Microsoft Knowledge Base:

2600912 

(http://support.microsoft.com/kb/2600912/
)
How to configure an SMTP relay for Office 365

View article:
Some messages are rejected when you try to use Exchange Online servers as an SMTP relay for on-premises business applications and network hardware devices

How to use the Histogram add-in in Excel

This step-by-step article describes how to create a
histogram with a chart from a sample set of data. The Analysis ToolPak that is
included with Microsoft Excel includes a Histogram tool.

Verify Installation of the Analysis ToolPak

Before you use the Histogram tool, you need to make sure the
Analysis ToolPak Add-in is installed. To verify whether the Analysis ToolPak is
installed, follow these steps:

  1. In
    Microsoft Office Excel 2003 and in earlier versions of Excel, click Add-Ins on
    the Tools menu.

    In
    Microsoft Office Excel 2007, follow these steps:

    1. Click the Microsoft Office Button, and then click Excel
      Options
      .
    2. Click the Add-Ins category.
    3. In the Manage list, select
      Excel Add-ins, and then
      click Go.

    In Microsoft Office Excel 2010, follow these steps: 

    1. Click the File Button, and then click Excel Options.
    2. Click the Add-Ins category.
    3. In the Manage list, select Excel Add-ins, and then click Go.

  2. In the Add-Ins dialog box, make sure that the Analysis
    ToolPak
    check box under Add-Ins available is selected.
    Click OK.

NOTE: In order for the Analysis ToolPak to be shown in the Add-Ins dialog box, it must be installed on your computer. If you do not
see Analysis ToolPak in the Add-Ins dialog box, run Microsoft Excel Setup and add this component to
the list of installed items.

Create a Histogram

  1. Type the following in a new worksheet:
        A1:  87      B1: 20
        A2:  27      B2: 40
        A3:  45      B3: 60
        A4:  62      B4: 80
        A5:   3      B5:
        A6:  52      B6:
        A7:  20      B7:
        A8:  43      B8:
        A9:  74      B9:
       A10:  61     B10:
    					
  2. In
    Excel 2003 and in earlier versions of Excel, click Data Analysis on
    the Tools menu.

    In Excel 2007 and Excel 2010, click Data
    Analysis
    in the Analysis group on the the Data tab.

  3. In the Data Analysis dialog box, click Histogram, and then click OK.
  4. In the Input Range box, type A1:A10.
  5. In the Bin Range box, type B1:B4.
  6. Under Output Options, click New Workbook, select the Chart Output check box, and then click OK.

A new workbook with a Histogram table and an embedded chart is
generated.

Based on the sample data from step 1, the Histogram table
will look like the following table:

   A1: Bin     B1: Frequency
   A2:  20     B2:        2
   A3:  40     B3:        1
   A4:  60     B4:        3
   A5:  80     B5:        3
   A6: More    B6:        1
				

And, your chart will be a column chart that reflects the data in
this Histogram table.

Excel counts the number of data points in each
data bin. A data point is included in a particular data bin if the number is
greater than the lowest bound and equal to or less than the greater bound for
the data bin. In the example here, the bin that corresponds to data values from
0 to 20 contains two data points, 3 and 20.

If you omit the bin
range, Excel creates a set of evenly distributed bins between the data’s
minimum and maximum values.

NOTE: You will not be able to create the Histogram chart if you
specify the options (Output range or New worksheet ply) that create the Histogram table in the same workbook as your
data.

For more
information, click the following article number to view the article in the
Microsoft Knowledge Base:

214029 

(http://support.microsoft.com/kb/214029/
)

Using Data Analysis tools on grouped sheets

Read more here:
How to use the Histogram add-in in Excel

How to use the Office 2000 Clipboard

Office 2000 includes a new clipboard called the Office
Clipboard. You can use this clipboard to collect and paste multiple items. For
example, you can copy a drawing object in Microsoft Excel, switch to Microsoft
PowerPoint and copy a bulleted list, switch to Microsoft Internet Explorer and
copy a page of text, and then switch to Microsoft Word and paste the collection
of copied items.

NOTE: You can copy items while using any program that provides copy
and cut functionality, but you can only paste items into Word, Excel,
PowerPoint, Microsoft Access, or Microsoft Outlook.

What Is Copied to the Office Clipboard

The Office Clipboard automatically copies multiple items when you
do any of the following:

  • Copy or cut two different items consecutively in the same
    program.
  • Copy an item, paste the item, and then copy another item in
    the same program.

In versions of Excel earlier than Excel 2000, you can copy and
paste an item anywhere within a worksheet until you perform an action that
clears the clipboard. The Office Clipboard retains information about pasted
items so that you can perform other tasks without clearing the clipboard and
then paste items as you need them. The Office Clipboard does not replace the
Windows Clipboard, which can only store a single item.

Limitations of the Office Clipboard

The Office Clipboard has the following limitations:

Controlling the Office Clipboard

As you copy items, the Office Clipboard automatically appears on
your desktop. You can close it if you do not want it to appear automatically.
After closing the toolbar three times, you are prompted to permanently close
it. If you permanently close the clipboard, to redisplay it, on the View menu, click Toolbars and then click Clipboard. If you want to reset the automatic appearance functionality,
right-click the Assistant, click Options and on the Options tab, click Reset my Tips.

Clearing the Office Clipboard

You can easily clear all the items that are stored in the
Office Clipboard. To clear the Office Clipboard, click Clear All on the Clipboard toolbar.

By modifying the Windows registry, you can turn off the
Office Clipboard so that it no longer automatically appears in any Office
program. For more information about how to do this, please click the article
number below to view the article in the Microsoft Knowledge Base:
207438 

(http://support.microsoft.com/kb/207438/EN-US/
)

OFF2000: Preventing the Office Clipboard Toolbar from Appearing

Read the original post:
How to use the Office 2000 Clipboard

Changes to .xls file in offline folder is not synchronized automatically on Windows 7

Consider the following scenario:
  • You share a folder on Windows server. On Windows 7, you make this shared folder offline.
  • There is an .xls file in this folder.
  • You edit the .xls file, and then you save the .xls file to the offline folder.
  • You open the file from another computer.

In this scenario, you find that the changes to the file were not saved. When you manually synchronize the offline folder, you’re notified of file conflict between file on the server and on this machine.

Note This is a “FAST PUBLISH” article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.

Read the article:
Changes to .xls file in offline folder is not synchronized automatically on Windows 7

Excel 2007/2010 – How to automatically populate the "Connection Files on the Network" section of Existing Connections on Data Tab

How to automatically populate Data > Existing Connections > “Connection files on the Network” via registry fix.

RESOLUTION

Windows Registry Editor Version 5.00

HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0CommonServer LinksPublishedMy SiteServerName

“LinkType”=hex(b):00,00,00,04,00,00,00,00

“IsMember”=dword:00000000

“IsPublished”=dword:00000001

“Url”=//ServerName/Folder

Note This is a “FAST PUBLISH” article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.

Original post:
Excel 2007/2010 – How to automatically populate the "Connection Files on the Network" section of Existing Connections on Data Tab

Percentage format in pasted chart data table and axis will change to Numeric when source workbook is closed

Assume below scenario:

  1. Create test1.xlsx, input some data with % format.
  2. Create a chart based the data, then show data table from Chart Tools->Layout->Data table->Show Data Table
  3. Create a new workbook, named test2.xlsx
  4. Copy chart from test1.xlsx to test2.xlsx

When you close test1.xlsx, in test2.xlsx you will find percentage (%) format in chart data table and axis changes to numeric format.

By default, data table and axis formatting of pasted chart are linked to source workbook. Once the source workbook is closed, the link is lost, and hence percentage (%) format is changed to default numeric format.

For axis , you can avoid this issue by unlinking the axis formatting:

  1. Right click axis in chart
  2. Click Format Axis
  3. Click Number tab
  4. Uncheck “Linked to Source” checkbox

For data table, it is always linked to source data so the issue cannot be avoided.

Note This is a “FAST PUBLISH” article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.

Excerpt from:
Percentage format in pasted chart data table and axis will change to Numeric when source workbook is closed

The Import Organization Wizard takes a long time to import an organization in Microsoft Dynamics CRM 4.0

You try to use Deployment Manager to import an organization
to Microsoft Dynamics CRM 4.0. However, the Import Organization Wizard takes a
long time to import the organization.
This problem occurs because there are many system user
references that must be updated.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 

(http://support.microsoft.com/kb/322756/
)
How to back up and restore the registry in Windows

This problem is fixed in the latest cumulative
update rollup for Microsoft Dynamics CRM 4.0.
For more
information, click the following article number to view the article in the
Microsoft Knowledge Base:

949256 

(http://support.microsoft.com/kb/949256/
)

Microsoft Dynamics CRM 4.0 updates and hotfixes

After you install this hotfix, to have us add the OptimizeOrgImport REG_DWORD registry entry for you, go to the “Fix it for me” section. If you prefer to add the OptimizeOrgImport REG_DWORD registry entry yourself, go to the “Let me fix it myself” section.

Fix it for me

To add the OptimizeOrgImport REG_DWORD registry entry automatically, click the Fix it button or link.
Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

Notes

  • This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
  • If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Then, go to the “Did this fix the problem?” section.

Let me fix it myself

After you install this hotfix, you must add the OptimizeOrgImport REG_DWORD registry entry on the Microsoft Dynamics CRM 4.0
server. To do this, follow these steps:

  1. Click Start, click Run,
    type regedit, and then click OK.
  2. Locate and then click the following registry subkey:

    HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSCRM

  3. Right-click MSCRM, point to
    New, and then click DWORD Value.
  4. Name this DWORD value as “OptimizeOrgImport”
  5. Right-click OptimizeOrgImport, and then
    click Modify.
  6. In the Value data box, type
    1, and then click OK.
  7. On the File menu, click
    Exit.

Note If you want to disable this hotfix, set the value of the
OptimizeOrgImport registry entry to 0.


Did this fix the problem?

  • Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support
    (http://support.microsoft.com/contactus)
    .
  • We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the “Fix it for me
    (http://blogs.technet.com/fixit4me/)
    ” blog or send us an email
    (mailto:fixit4me@microsoft.com?Subject=KB)
    message.
When you use the registry entry

OptimizeOrgImport

and have the value of this entry set to 1, you cannot import the same organization database more than one time. If you want to import the same organization database more than one time, you must do one of the following things:

  • Set OptimizeOrgImport = 0 and use the normal import process.
  • Delete the organization, and then import the organization again.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the “Applies to” section.

Taken from:
The Import Organization Wizard takes a long time to import an organization in Microsoft Dynamics CRM 4.0

Invalid Product Key Error Installing Access 2010

You receive an Invalid Product Key error when trying to install Access 2010 onto a machine that already has an Office 2010 suite installed.
The originally installed Microsoft Office 2010 suite may have included a trial version of the Microsoft Office 2010 Professional suite, which includes Microsoft Access 2010. If you attempt to upgrade the trial version of the Microsoft Office 2010 Professional Suite by entering a product key for a stand-alone copy of Microsoft Access 2010 as the upgrade key, the upgrade fails because a product key for the Microsoft Office 2010 Professional suite is required. A product key for an individual program within the Office 2010 Suite, such as Access, cannot upgrade the whole suite of programs in Office 2010 Professional nor can it upgrade one individual program from the suite, such as Access.
In order to install Access 2010, you will need to first remove the trial application from the machine.  After doing this, you will then need to install Access 2010 from the standalone Access 2010 media, which would either be an Access 2010 DVD or the Access 2010 downloaded media.

To remove the Access 2010 trial:

1. Close any Office 2010 applications that are open.
2. Choose the Add / Remove program option on Windows XP or the Uninstall a Program option on Windows Vista / Windows 7. This can be done through the control panel or by typing appwiz.cpl into a run command line from the Start menu.
3. Locate the previously installed Microsoft Office 2010 suite in the list of programs. The most common suites with a trial would be Office Home and Student 2010 or Office Home and Business 2010.
4. Select the Microsoft Office 2010 suite and then right click on it and choose Change.
5. In the Change dialog, select the Add or Remove Features option and then click on Continue.
6. Within the Installation Options dialog, click the black down arrow next to Microsoft Access and choose Not Available.
7. Click Continue.
8. Once the configuration process completes, click the Close button.

Note:  After going through these steps if you would like to completely remove the other Office 2010 trial applications from the machine, you can do so by going through the first set of steps in the following article: Remove or uninstall Office 2010 Trial
(http://office.microsoft.com/en-us/word-help/remove-or-uninstall-office-2010-trial-HA101972584.aspx)

To install Access 2010:

1. Locate the Access 2010 DVD or download the Access 2010 media from the site it was purchased from. If you do not have the media, you can download it by going through the steps in: Get a backup of Office 2010
(http://office.microsoft.com/en-us/products/microsoft-office-2010-backup-FX101853122.aspx)

2. Insert the Access 2010 DVD into the DVD ROM drive or double click on the downloaded media.
3. When prompted for a product key, type in the Access 2010 product key.
4. Complete the install process. 

Note This is a “FAST PUBLISH” article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.

More:
Invalid Product Key Error Installing Access 2010

Page 434 of 755« First...102030...432433434435436...440450460...Last »

Recent Comments

    Archives

    Categories