| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link updates Excel 2007
Hi,
We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust center - external contents. Excel shows then the cells in "value". I would like to start Excel without updating the links. Can somebody help me please? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link updates Excel 2007
Hi,
Try, Data, Edit Links (in the Connections group), Startup Prompt, Don't display the alert and don't update automatic links. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Alain Schneiter" wrote: Hi, We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust center - external contents. Excel shows then the cells in "value". I would like to start Excel without updating the links. Can somebody help me please? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link updates Excel 2007
Shane,
I tried this. Same problem. The spreadsheed points to a not available file share. The cells still shows "value". Cheers, Al "Shane Devenshire" wrote: Hi, Try, Data, Edit Links (in the Connections group), Startup Prompt, Don't display the alert and don't update automatic links. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Alain Schneiter" wrote: Hi, We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust center - external contents. Excel shows then the cells in "value". I would like to start Excel without updating the links. Can somebody help me please? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link updates Excel 2007
Hi,
Please check the names defined in the workbook. Do you have any names which evaluate to errors. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Alain Schneiter" <Alain wrote in message ... Hi, We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust center - external contents. Excel shows then the cells in "value". I would like to start Excel without updating the links. Can somebody help me please? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link updates Excel 2007
Hi,
Can you please explain a bit more what you mean. The workbook points to an external source. Regards, Al "Ashish Mathur" wrote: Hi, Please check the names defined in the workbook. Do you have any names which evaluate to errors. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Alain Schneiter" <Alain wrote in message ... Hi, We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust center - external contents. Excel shows then the cells in "value". I would like to start Excel without updating the links. Can somebody help me please? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link updates Excel 2007
Hi,
Click on Ctrl + F3 to see if you have any names which evaluate to error values I.e. #DIV/0!, #NUM etc.. Delete these names. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Alain Schneiter" wrote in message ... Hi, Can you please explain a bit more what you mean. The workbook points to an external source. Regards, Al "Ashish Mathur" wrote: Hi, Please check the names defined in the workbook. Do you have any names which evaluate to errors. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Alain Schneiter" <Alain wrote in message ... Hi, We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust center - external contents. Excel shows then the cells in "value". I would like to start Excel without updating the links. Can somebody help me please? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link updates Excel 2007
Hi,
Nothing like that in there. Any other idea? The file should not update the content as this is pointed to external not reachable files or fileshares. Cheers, Al "Ashish Mathur" wrote: Hi, Click on Ctrl + F3 to see if you have any names which evaluate to error values I.e. #DIV/0!, #NUM etc.. Delete these names. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Alain Schneiter" wrote in message ... Hi, Can you please explain a bit more what you mean. The workbook points to an external source. Regards, Al "Ashish Mathur" wrote: Hi, Please check the names defined in the workbook. Do you have any names which evaluate to errors. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Alain Schneiter" <Alain wrote in message ... Hi, We have svereal spreadsheets with exeternal contents. Excel 07 always starts with trying to update this links even if we change the settings in the trust center - external contents. Excel shows then the cells in "value". I would like to start Excel without updating the links. Can somebody help me please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic updates of links between files €“ Excel 2007 | Links and Linking in Excel | |||
| Link Updates | Excel Discussion (Misc queries) | |||
| Excel-to-Word Link Updates | Links and Linking in Excel | |||
| Excel Link Updates | Excel Worksheet Functions | |||
| Link Updates | Links and Linking in Excel | |||
Hybrid Mode
