Excel 2010 – cannot paste the data (copy screenshoot from sniping tools )

if you have problem with excel 2010 with below error :

excel-cannot paste the data

please do the following :

  • Click File ,
  • and then Options,
  • select the Advanced section,
  • then scroll down to the section ‘Display options for this workbook‘ and you want to set ‘For objects, show:’ to the ‘All‘ setting.
  • and then click ok.

excel-cannot paste the data_1

Outlook 2010 Error – Calendar Sharing is not available with the following entries because of permission settings on your network

one of my user complaining about sharing the calendar to other user.

When he’s try to send the calendar it will show below dialogue

calenda-sharing-is-not-available

after little bit googling i found that it will happens when you typed the recipients email address in or used the address from your cached addresses. And that make the calendar sharing will not working.

you have likely typed the recipients email address in or used the address from your cached addresses.

To delete the recipient email from cache you can do it like below picture.

delete-outlook-address-cache

 

Simple right 😀

 

source :

http://www.urtech.ca/2012/07/solved-calendar-sharing-is-not-available-with-the-following-entries-because-of-permission-settings-on-your-network/

 

 

Troubleshoot – Outlook 2010 Cannot create file

If you have problem like below error, when opened the attachment from outlook 2010

You can try to cleaning up this below folder, and then restart the outlook again. It’s simple right? 😀

C:\Users\USERNAME\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook

Source :

http://social.technet.microsoft.com/Forums/exchange/en-US/996d565f-aebd-49d1-863d-65a2228f8b57/cant-create-file-documentpdf-rightclick-the-folder-you-want-to-create-the-file-in-and-then?forum=exchangesvrclientslegacy

The Comma and Semicolon Issue in Excel Due to Regional Settings when open CSV file

There are a problem with excel 2010 that happened to my customer.When opening standard CSV (Comma Separated Values) files in Excel 2010 you may find that Excel did not recognize the fields and simply displays all data in the first column.

The problem is:

  • The standard field delimiters for CSV files are commas “,”
  • On American Windows versions, the comma is set as default for the “List Separator”, which is okay for CSV files.
  • But on European Windows versions this character is reserved as the Decimal Symbol and the “List Separator” is set by default to the semicolon “;”

After search the problem in google, I found a way to solved it. The solution is to change regional settings.

Please follow below step to solved it  :

  • go to Start | Control Panel | Regional and Language Options
  • Click Additional Settings
  • For Decimal Symbol, enter a dot  “.”
  • For List Separator, enter a comma “,”

Now, when you open a CSV file in Excel it will automatically find the data fields and open it appropriately. 😀

References Link :

http://www.paessler.com/knowledgebase/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this