如果表格1中有些資料是在表格2中拷取的,如表格1的A2等如表格2的E3等或VLOOKUP等程式.在儲存時,要將它倆存至另一电腦或發电郵時,往往那些程式会出混亂,請問有什么方法可避免??
Excel 程式儲存問題
2011-02-23 10:17 am
回答 (2)
2011-02-24 7:17 am
如對方不要知道表格2的資料
convert the value of 表格1 to value.
Save 表格1 as new file (say file2)
highlight all cell of file2
right click and then select "copy"
right click and then select "paste special" and then select "value"
save file2 and send file2 to others
convert the value of 表格1 to value.
Save 表格1 as new file (say file2)
highlight all cell of file2
right click and then select "copy"
right click and then select "paste special" and then select "value"
save file2 and send file2 to others
收錄日期: 2021-04-13 17:50:17
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20110223000051KK00126