EXCEL GETDOCUMENT 公式
■ 定義兩個名稱：

插入＼名稱＼定義

◆ 第一個定義名稱：

「名稱」輸入「頁數編號」，「參照到」輸入下列公式
=IF(ISNUMBER(MATCH(ROW(),GET.DOCUMENT(64),1)),MATCH(ROW(),GET.DOCUMENT(64),1)+1,1)

◆ 第二個定義名稱：
「名稱」輸入「總頁數」，「參照到」輸入下列公式
=GET.DOCUMENT(50)

■ 工作表中建立公式
1.檔案＼列印範圍＼設定列印範圍

2.選定儲存格，建立以下公式 :
="第 " & 頁數編號 & " 頁"&"共 "&總頁數& "頁"


GET.DOCUMENT裡應有 89 個參數
其中
1       文件名稱
2       儲存路徑
3       文件型態
8       視窗保護
9      第一使用列號
10    最後使用列號
11    第一使用欄號
12    最後使用欄號
14    計算類型
16    反覆運算最高次數
17    最大誤差
18    更新遠程參照
19    活頁簿以顯示值為準
20    1904年日期系統
21    標準字體
22    字體大小
34    建議唯讀
35    修改權設定密碼
36    使用者名稱
41    物件
43    儲存外部連結資料
48    標準欄寬
50    共印幾頁
52    邊界
53    頁面方向
54    自訂頁首
55    自訂頁尾
56    水平置中
57    列印欄名列號
58    列印格線
59    儲存格單色列印
61    循欄或列列印
62    版面設定縮放比例
65    視窗可見欄數
68    檔案名稱
76    同1
88    同68

http://kb.vmware.com...stateId=1 0 19462003
This error is seen because the VMware virtual bridge can operate at any speed and is constrained only by the processing power of the host computer's processor. When traffic is sent from the guest to the host it can be sent at very fast speeds.  Windows Server 2003 includes security features that interpret network requests at speeds above a specified limit as denial of service attacks. In response, Windows Server 2003 disconnects the client — in this case, the guest VM.  Once it is disconnected Windows will not allow it to connect again.

There are several ways you can avoid such disconnections. Use the one that is most convenient in your environment.

Use the bandwidth limiting feature of VMware Workstation 5 (this workaround does not apply to GSX Server). Using a text editor, add two lines to the configuration (.vmx) file of the affected virtual machine.

If the physical Ethernet adapter on the host computer is running at 100Mbps, use the following two lines:
ethernet0.txbw.limit=100000
ethernet0.rxbw.limit=100000

If the physical Ethernet adapter on the host computer is running at 10Mbps, use the following two lines:
ethernet0.txbw.limit=10000
ethernet0.rxbw.limit=10000

In both examples above, the setting affects the virtual machine's first virtual Ethernet adapter (ethernet0). To modify the setting for a second virtual Ethernet adapter, substitute ethernet1. For a third virtual Ethernet adapter, use ethernet2.

This approach increases the load on the host computer's processor and may affect performance.

Disable large send offload in the network settings for the physical Ethernet adapter on the host computer. Note: This is host operating system dependent, not a VMware setting.

This approach increases the load on the host computer's processor and may affect performance.

Use a gigabit switch. Connecting the host computer's network adapter to a gigabit switch helps because the bridge cannot produce traffic that exceeds the 1000Mbps speed of the switch. This workaround provides the highest throughput when you copy large files.

Change the configuration of the virtual machine to use host-only networking. This change is simple to make and may be appropriate for some virtual machines.

Disable or change the Windows Server 2003 settings on the host to disable the security feature.  Note: this may increase the security risk of the host as it affects connections to external hosts as well.  See: http://support.microsoft.com/kb/898468 for instructions on how to do this.