Skype click to call excel

How to Use Skype With Excel

By Matthew Schieltz

Skype is an application that is made for business or personal, to make phone calls at low prices. The application uses an active Internet connection to make calls to people all over the world. Skype has introduced a useful add-on toolbar for anyone who has Microsoft Excel or other Office applications and wants to integrate the use of Skype with those programs. To use this toolbar you need to have the Skype application already installed on your computer.

Step 1

Download the Skype Office toolbar. This toolbar adds an icon or ribbon to Excel which allows you to use Skype from inside any Excel document. The Office Toolbar can be downloaded from the official Skype website at www.skype.com/download/skypeofficetoolbar/. Click on the «Download Now» button to begin the application download.

Step 2

Install the toolbar application in Excel. In most cases, and in Windows operating systems, you simply need to double-click on the downloaded .exe (executable) file to begin the installation process. When installing the Skype Toolbar, select your default language when prompted and accept the Skype end user and privacy agreement.

Step 3

Open a Microsoft Excel document. If using Excel 2007 click the ribbon labeled «Skype,» which should be located to the right of the other Office ribbons.

Step 4

Click the «Create Skype Links» or «Highlight Numbers» button on the Skype Office Toolbar. Both of these commands highlight all ten-digit phone numbers within an Excel document, but each button works differently. The «Create Skype Links» button adds a hyperlink to each phone number while the «Highlight Numbers» button adds SmartTags to phone numbers.

Step 5

Click on a phone number within your Excel document. If you click on a number that is hyperlinked, the Skype application will open asking you to confirm the calling of a telephone number. If you click on a number highlighted with a SmartTag, choose the «Call this number with Skype» menu option to make a call. Use your headset or microphone to proceed with your conversation.

• Refer to the official Skype website or Skype community forums for help in using the Toolbar.

Matthew Schieltz has been a freelance web writer since August 2006, and has experience writing a variety of informational articles, how-to guides, website and e-book content for organizations such as Demand Studios. Schieltz holds a Bachelor of Arts in psychology from Wright State University in Dayton, Ohio. He plans to pursue graduate school in clinical psychology.

Источник

Как пользоваться Skype из MS Excel

Skype — это ориентированное как на частного, так и на корпоративного пользователя приложение, позволяющее осуществлять недорогие телефонные звонки по всему миру. Как-то Skype представила очередное полезное дополнение, в это раз в виде специальной панели инструментов, которая позволяет пользователям, часто работающим с Excel и другими офисными приложениями Microsoft, интегрировать приложение Skype в эти программы.

Однако, чтобы использовать новую панель с MS Excel необходимо сначала установить Skype на свой компьютер. Кроме того, также понадобятся программа Skype Office Toolbar и гарнитура.

Чтобы установить, настроить и использовать Skype с Excel сделать нужно следующее:

1. скачиваем Skype Office toolbar. Эта панель интегрирует Skype в Excel. Проще говоря, после установки этой программы в Excel появится иконка Skype, и в дальнейшем Skype можно будет пользоваться непосредственно из любого документы Excel. Скачать Skype Office toolbar можно с официального сайта вот по этой ссылке: www.skype.com/download/skypeofficetoolbar/

2. после загрузки приложение Office toolbar нужно уставовить в Excel. В ОС Windows и большинстве других систем для того, чтобы начать процесс инсталляции, достаточно просто дважды кликнуть по иконке файла-установщика приложения. После установки Skype
Office toolbar предложит выбрать язык интерфейса и традиционно предоставит к изучению текст пользовательского соглашения. Выбираем, читаем, подтверждаем.

3. открываем любой документ Microsoft Excel, отыскиваем значек Skype среди других на верхней панели управления Microsoft Excel (а также Word и PowerPoint). Кликаем.

4. далее кликаем по кнопкам «Create Skype Links» или «Highlight Numbers» в панели программы Skype Office Toolbar. Каждая из этих команд выделяет 10-значные телефонные номера, которые могут содержаться в документе Excel, однако работают они по-разному: первая ставит гиперссылку на номер, вторая — добавляет смарт-тег.

5. кликаем на телефонный номер в документе Excel. Если он оформлен в виде гиперссылки, то Skype, прежде чем начать набор, попросит подтвердить намерение позвонить по этому номеру. А если кликнуть по выделенному номеру, который сопровождается смарт-тегом, то, чтобы позвонить, надо еще раз нажать на табличку «Call this number with Skype». Для разговора может понадобиться гарнитура.

Источник

SmoothSpan Blog

For Executives, Entrepreneurs, and other Digerati who need to know about SaaS and Web 2.0.

Blog Tools

Archives

Recent Comments

Pages

March 2012

M	T	W	T	F	S	S
1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

Top Posts

Recent Posts

OMG: Skype Click to Call Breaks Excel so it can Only Paste Text.

Posted by Bob Warfield on March 24, 2012

This is an amazing bug that should be getting a lot more press. I discovered it when I found that several Excel worksheets I regularly update were suddenly producing the wrong answers. I went and looked and saw that instead of copying formulas when I cut and pasted, Excel was acting as if it was copying and pasting the text. Essentially the formulas were lost. When you think about all the things spreadsheets are used for, and how many of them are suddenly producing the wrong answers as a result of this problem, it’s scary.

Worse, I have no recollection of even being asked whether I wanted to install Skype Click to Call, it just happened. It’s a browser add-in that is visible in IE and completely invisible in Chrome. At least I couldn’t find it listed as an add-on yet I had to close all my Chrome windows to be able to uninstall it.

Skype has always been pretty sleazy and spammy–I hate a program where you can’t shut it down once it starts up unless you use the Task Manager or reboot–but this is ridiculous.

Help get the word out to uninstall Skype Click to Call ASAP if you use Excel at all. You will not be happy to discover your spreadsheets are wrong!

Share this:

Like this:

This entry was posted on March 24, 2012 at 7:36 pm and is filed under saas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

6 Responses to “OMG: Skype Click to Call Breaks Excel so it can Only Paste Text. ”

schlafly said

Wait — are you saying that some Skype browser widget is somehow sabotaging your Excel formulas?! I have heard that Skype plays rude games to get thru firewalls, but how would it get to your formulas?

Microsoft bought Skype, so maybe Msft will clean up the mess some day.

Bob Warfield said

Exactly what I’m saying, Roger.

It works by changing the behavior of cut and paste. Instead of cutting and pasting a cell’s formula and formats, it was turning the contents of the clipboard into text with formats. What you’d see looked like a successful paste–numbers and formats would appear in the pasted cells. What you might not realize until later was that cells that should have formulas would only have text that was the value of the cell you copied. So, if I had a column of cells that count up due to formulas like “=1+A1”. Let’s say I took row 2, which uses that formula to refer to row 1 and increment, and paste it down 100 rows. What’d I’d get is instead of it pasting the formula, it would just paste the value, “2”, in all those rows.

Devilishly clever these Skype guys. I assume some aspect of their click to call does this to clipboard contents for some reason. I saw references to similar problems in Word, though they’re not as bad because Word doesn’t use formulas. It would simply screw up the table formatting somehow.

dougaross said

Bob you are absolutely correct. I run firefox 11.0 and I found the same problem. In fact I was running Office 2000, so I figured it was time to upgrade to Office 2010. Which didn’t solve the problem.

It was very confusing since after a reboot the problem went away, but I hadn’t run my browser yet. The key was to disable Click to Call in my browser add-ins. Problem solved.

BTW: another symptom of this problem is when you select a cell and do a copy the cell border does not turn into little dashed lines.

timothytim said

It affects any paste you try to do into any MSOffice application, whether it is from a MSWord doc to another MSWord doc, from MSWord to MSExcel, or from your browser into either of them. What happens is that only text is copied, no formatting, formulas etc. I didn’t try it with Powerpoint, etc, but suspect the same for all MSOffice apps.

This is confirmed also at the following link. It’s on MS Radar, but they apparently haven’t shot it down yet.

Julia Keating Campbell said

I can so confirm this problem. Thank you to all of the above. I removed Skype Click to Call .. which somehow in the last week or two installed itself on my computer … the same duration I was having problems with cut and paste of entries including formulas in Excel 2003. Removal and reboot has solved the problem. Skype people .. Go have a good hard look at yourself and fix this malicious software problem you have introduced to the world.

Baron Von Sternberg said

Yes, I had the same problem with copy-paste in general. In fact, every time I opened Chrome, I was unable to keep the formatting when trying to copy-paste anything, in any program (Word, Excel etc), even after closing Chrome. There was no icon to click upon and choose formatting. Funniest of all: when I tried to copy and paste a part of a document in “Scientific workplace” (a program that allows you to write text and mathematics as in Word, but producing files written in Latex), instead of pasting the original, its was the Latex code that was pasted! I thought that was a mysterious problem of Chrome, but making an internet search I discovered that it was Skype click to call that was the source of the problem.

Note that this problem did not exist in the past.

Источник

How to Use Skype With Excel

By Matthew Schieltz

Skype is an application that is made for business or personal, to make phone calls at low prices. The application uses an active Internet connection to make calls to people all over the world. Skype has introduced a useful add-on toolbar for anyone who has Microsoft Excel or other Office applications and wants to integrate the use of Skype with those programs. To use this toolbar you need to have the Skype application already installed on your computer.

Step 1

Download the Skype Office toolbar. This toolbar adds an icon or ribbon to Excel which allows you to use Skype from inside any Excel document. The Office Toolbar can be downloaded from the official Skype website at www.skype.com/download/skypeofficetoolbar/. Click on the «Download Now» button to begin the application download.

Step 2

Install the toolbar application in Excel. In most cases, and in Windows operating systems, you simply need to double-click on the downloaded .exe (executable) file to begin the installation process. When installing the Skype Toolbar, select your default language when prompted and accept the Skype end user and privacy agreement.

Step 3

Open a Microsoft Excel document. If using Excel 2007 click the ribbon labeled «Skype,» which should be located to the right of the other Office ribbons.

Step 4

Click the «Create Skype Links» or «Highlight Numbers» button on the Skype Office Toolbar. Both of these commands highlight all ten-digit phone numbers within an Excel document, but each button works differently. The «Create Skype Links» button adds a hyperlink to each phone number while the «Highlight Numbers» button adds SmartTags to phone numbers.

Step 5

Click on a phone number within your Excel document. If you click on a number that is hyperlinked, the Skype application will open asking you to confirm the calling of a telephone number. If you click on a number highlighted with a SmartTag, choose the «Call this number with Skype» menu option to make a call. Use your headset or microphone to proceed with your conversation.

• Refer to the official Skype website or Skype community forums for help in using the Toolbar.

Matthew Schieltz has been a freelance web writer since August 2006, and has experience writing a variety of informational articles, how-to guides, website and e-book content for organizations such as Demand Studios. Schieltz holds a Bachelor of Arts in psychology from Wright State University in Dayton, Ohio. He plans to pursue graduate school in clinical psychology.

Источник

Отсутствуют специальные параметры вставки в Excel 2010

В Excel каждый раз, когда я копирую и вставляю, копируется только текст, а форматирование не копируется, как показано на рисунке ниже:

При вставке нет специальных параметров вставки.

На рисунке выше я скопировал ячейку A1 используя CTRL + C, и вставил в ячейку A3 используя CTRL + V. Вставлен только текст, а форматирования не было.

Это то, что я пытался без удачи:

1. Восстановленный MS Office с LIVE CD.
2. Проверял формат ячеек.
3. Пробовал закрывать все экземпляры Excel.

Интересно, что когда я вставил специальные параметры, как показано на скриншоте ниже, были доступны только параметры Text и Unicode .

7 ответов 7

У меня возникла та же проблема, и я удалил (или поставил «отключить») надстройку «Skype Click to Call» из Skype в браузере IE в разделе «Свойства обозревателя» и на вкладке «Программы» — «Управление надстройками», это было решено. Похоже, что новая версия Skype добавляет это «дополнение».

Во-первых, попробуйте запустить в безопасном режиме: Excel.exe /Safe (в команде run), если там все работает правильно, это означает, что это связано с надстройкой или книгой, загруженной при запуске.

(Файл> Параметры> Надстройки — снимите все надстройки). Отметьте, какие из них были выбраны. Закройте Excel, а затем снова откройте его

Если это работает, то проблема связана с одним из надстроек, просто нужно найти какой, включив их один за другим.

Если это не сработало, то это, вероятно, из-за одного файла, расположенного в каталоге автозагрузки Excel. (например, C:\Program Files\Microsoft Office\Office14\XLSTART для меня)

Любой файл там загружается при запуске Excel. Удалите файлы из этой папки и откройте Excel, чтобы увидеть, исчезла ли проблема.

если это работает, добавляйте их обратно по одному, закрывая и открывая Excel каждый раз, пока вы не определите, какой файл был поврежден.

Источник