Topic:Save a linked sheet in Excel & Freeze it Remainpoint:0
   
PostTime:12/16/2008 5:29:40 PM FloorTop
Lv is 1
Avatar
Level:
1
Professional point:
52
Experience:
2
Thread:
291
Post:
928
Total online time:
2M
Joined date:
4/28/2007 10:52:00 PM
Last Visit:
12/17/2008 12:08:28 AM
Status:
Offline
How do I save one linked sheet from an Excel document as a seperate document without it updating every time the main document is updated. Esentially, I want the seperate document to "freeze" when I save it seperately. Here is what I did - Edit - Move or Copy - Create a Copy in New Book. This workes fine - but it updates & I don't want it to. I know that when I open it, it will ask to update or not - but I am not always the person opening it - so I want that removed as an option.
 
     
   
Gender PostTime:12/16/2008 7:36:10 PM Point:0 | Floor# 1
Lv is 1
portrait
Level:
1
Professional point:
32
Experience:
5
Thread:
287
Post:
980
Total online time:
5M
Joined date:
4/29/2007 12:12:00 AM
Last Visit:
12/16/2008 11:58:01 PM
Status:
Offline
I am just creating a copy - but when I open it, it asks if I want to update it - I don't.
 
     
   
Gender PostTime:12/16/2008 10:22:03 PM Point:0 | Floor# 2
Lv is 1
portrait
Level:
1
Professional point:
87
Experience:
35
Thread:
282
Post:
936
Total online time:
35M
Joined date:
4/28/2007 11:15:00 PM
Last Visit:
12/16/2008 11:26:43 PM
Status:
Offline
A good link tool is by Bill Manville, http://www.bmsltd.ie/MVP/Default.htm
 
     
1

Sorry, you are not login, click here to login

 

About us | Advertise | Contact us | Partner | Bug Report|Suggesting box|Donation
Home | Forum | Affiliate program| Remote help | Setting | Search | Document | Help | Download|Message

 

Start new topicAdvanced search