Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links Automatically refreshing in Excel 2007
I'm trying to find a way to stop linked documents being automatically
refreshed in Excel 2007. In 2003 you used to get a pop-up that prompted if you wanted to update your links or not. 2007 doesn't do this and automatically updates them. I have tried unticking the box for "update links to other documents" but they still update. I noticed in the Edit links section it has a bit for Update: Automatic/Manual but Manual is always greyed out. I also tried the macro that Tom Ogilvy and Jason put up but that doesn't work either. Please help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links Automatically refreshing in Excel 2007
Hi,
It sounds like your security bar is turned off. Choose Office Button, Excel Options, Trust Center, Trust Center Settings, and then click Message Bar. Now when you open a file that contains links you should see the security bar directly below the ribbon, if you click the Option button it will display a screen where you can choose to enable the updating of links at any time or you can do nothing and the links won't be updated. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Bronwyn" wrote: I'm trying to find a way to stop linked documents being automatically refreshed in Excel 2007. In 2003 you used to get a pop-up that prompted if you wanted to update your links or not. 2007 doesn't do this and automatically updates them. I have tried unticking the box for "update links to other documents" but they still update. I noticed in the Edit links section it has a bit for Update: Automatic/Manual but Manual is always greyed out. I also tried the macro that Tom Ogilvy and Jason put up but that doesn't work either. Please help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links Automatically refreshing in Excel 2007
The bar pops up fine but if you open the source file at all then it
automatically updates. For example: create 2 documents one called destination.xlsx and one called source.xlsx. In the file source.xlsx put the number 1 in cell A1. Save it. In cell A1 of destination.xlsx put ='[path to file]\[source.xlsx]source.xlsx'!$A$1. Untick "Update links to other documents" and save the file. Close both documents. Open destination.xlsx and the bar pops up saying that automatic updating of file disabled. Leave that as is. Now, open source.xlsx and modify cell A1 to 123. Switch back to destination.xlsx and it will have changed. "ShaneDevenshire" wrote: Hi, It sounds like your security bar is turned off. Choose Office Button, Excel Options, Trust Center, Trust Center Settings, and then click Message Bar. Now when you open a file that contains links you should see the security bar directly below the ribbon, if you click the Option button it will display a screen where you can choose to enable the updating of links at any time or you can do nothing and the links won't be updated. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Bronwyn" wrote: I'm trying to find a way to stop linked documents being automatically refreshed in Excel 2007. In 2003 you used to get a pop-up that prompted if you wanted to update your links or not. 2007 doesn't do this and automatically updates them. I have tried unticking the box for "update links to other documents" but they still update. I noticed in the Edit links section it has a bit for Update: Automatic/Manual but Manual is always greyed out. I also tried the macro that Tom Ogilvy and Jason put up but that doesn't work either. Please help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links Automatically refreshing in Excel 2007
bump
"Bronwyn" wrote: The bar pops up fine but if you open the source file at all then it automatically updates. For example: create 2 documents one called destination.xlsx and one called source.xlsx. In the file source.xlsx put the number 1 in cell A1. Save it. In cell A1 of destination.xlsx put ='[path to file]\[source.xlsx]source.xlsx'!$A$1. Untick "Update links to other documents" and save the file. Close both documents. Open destination.xlsx and the bar pops up saying that automatic updating of file disabled. Leave that as is. Now, open source.xlsx and modify cell A1 to 123. Switch back to destination.xlsx and it will have changed. "ShaneDevenshire" wrote: Hi, It sounds like your security bar is turned off. Choose Office Button, Excel Options, Trust Center, Trust Center Settings, and then click Message Bar. Now when you open a file that contains links you should see the security bar directly below the ribbon, if you click the Option button it will display a screen where you can choose to enable the updating of links at any time or you can do nothing and the links won't be updated. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Bronwyn" wrote: I'm trying to find a way to stop linked documents being automatically refreshed in Excel 2007. In 2003 you used to get a pop-up that prompted if you wanted to update your links or not. 2007 doesn't do this and automatically updates them. I have tried unticking the box for "update links to other documents" but they still update. I noticed in the Edit links section it has a bit for Update: Automatic/Manual but Manual is always greyed out. I also tried the macro that Tom Ogilvy and Jason put up but that doesn't work either. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 automatically redirects links - Linking Problem #2!! | Links and Linking in Excel | |||
Automatically Refreshing Data at 12am | Excel Discussion (Misc queries) | |||
Automatically Refreshing Data at 12am | Excel Worksheet Functions | |||
Pivot Tables are Automatically refreshing | Excel Discussion (Misc queries) | |||
Refreshing Links On "Calculate" | Excel Discussion (Misc queries) |