Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.access.externaldata,microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Shared file keeps losing connection
I have a shared workbook, and sometimes when I work on it, it seems to lose
connection with the shared file. (as it happens, its a 2003 file operating on both 2003 and 2007, but I don't think that's related to the problem) The workbook has VBA modules in, nothing very complicated though. and I get the following message: 'You are no longer connected to this file. Another user may have removed you, or saved over it.' The file is always still there, and we haven't been removed. It is infuriating for everyone involved. Is there a way of getting it to automatically reconnect? or stopping it from dropping the connection in the first place? Thanks... M |
#2
Posted to microsoft.public.access.externaldata,microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Shared file keeps losing connection
Michelle,
FYI... microsoft.public.access.* is for Microsoft Access the database product, not *access* to workbooks in Excel. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Michelle" wrote in message ... I have a shared workbook, and sometimes when I work on it, it seems to lose connection with the shared file. (as it happens, its a 2003 file operating on both 2003 and 2007, but I don't think that's related to the problem) The workbook has VBA modules in, nothing very complicated though. and I get the following message: 'You are no longer connected to this file. Another user may have removed you, or saved over it.' The file is always still there, and we haven't been removed. It is infuriating for everyone involved. Is there a way of getting it to automatically reconnect? or stopping it from dropping the connection in the first place? Thanks... M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
Losing data on a shared workbook | Excel Discussion (Misc queries) | |||
Problems losing changes in shared workbook | Excel Worksheet Functions | |||
Shared workbook losing print settings | Excel Discussion (Misc queries) |