Office for mac2011破解方法

首先先下载并安装试用版的office for mac 2011
1点击finder


2点击系统盘


3点击资源库


4找到Preferences文件夹


5用压缩包里的com.microsoft.office.licensing.plist替换本身的Preferences文件夹里的com.microsoft.office.licensing.plist

。ok

Download com.microsoft.office.licensing.plist from here: 
http://bbs.weiphone.com/read-htm-tid-2109946.html

注意：
--------
直接拷贝com.microsoft.office.licensing.plist这个文件到Preferences文件夹，【不会】自动替换原来的文件，而是重命名为com.microsoft.office.licensing.1.plist

所以你要先把原来的删掉，再把破解文件放进去。

可能这就是很多人没有破解成功的原因~

Create a PIE Chart, counting how many entries you have for one column

Create a PIE Chart, counting how many entries you have for one column
=COUNTIFS(Data!L:L,B4)Name of the sheet: Datacolumn: LB4: The text(assigned group) you want to count.

Add a date range in the Excel report spreadsheet

How to add a daet range so you can just change the data on the Excel Spreadsheet and click on refresh.

Add a date range in the report spreadsheet:
From Start Date
To End date

Go into the data tab, click on Connections

In the workbook connections, select the data connection > Click on properties

Click on Edit Query.


Add in a field 'Reported date' change the date to >=[Parameter1] And <[Parameter2]
=[Parameterl lAnd

Close the query and go into data connection > Click on properties > Go to Definition Tab > Click on Parameters:
Click on 'Get the value from the following cell'
Define the correct cells for Parameter 1 -> start date
Select the correct date for Parameter 2 -> end date

Create a new Macro to refresh the Excel data

Create a new Macro and paste the below command

Sub Update()
'
' Update Macro
'

'
Range("A6").Select
ActiveWorkbook.RefreshAll
End Sub

Click on the Insert tab and select 'button'


Click anywhere in the Spreadsheet
You will get the below prompt, click on update to use the Macro you just created and click on ok

Now you are ready to use your Macro refresh button!

Issue: Unable to connect to the computer

Problem:

You cannot remote assist them via Altiris/ping/connect to the computer.

Providing that they are connected to the network - able to get Emails/have access to network drives...

They will need to run the below commands.

“NETSH INT IP RESET” to reset tcpip
“netsh winsock reset catalog” to reset the winsock