| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why errors occur in wrkbook w/ vba when saved on Shared folder?
I have a spreadsheet with VBA programming. The spreadsheet is used by
multiple people so the file is placed on a shared drive. When a user tries to open the file placed on shared drive, there will be an excel error and excel shuts down. However, when the file is saved on a desktop or opened from email, there are no errors. What would cause this error on a shared drive? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why errors occur in wrkbook w/ vba when saved on Shared folder?
Could be a sharing violation.
try: Tools/share workbook "Shawna Hartman" wrote: I have a spreadsheet with VBA programming. The spreadsheet is used by multiple people so the file is placed on a shared drive. When a user tries to open the file placed on shared drive, there will be an excel error and excel shuts down. However, when the file is saved on a desktop or opened from email, there are no errors. What would cause this error on a shared drive? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared workbook errors | Excel Worksheet Functions | |||
| Why does my shared spreadsheet have formula errors? | Excel Worksheet Functions | |||
| Adding a field to an excel sheet saved in a network shared folder | Excel Discussion (Misc queries) | |||
| Shared sheet errors | Excel Discussion (Misc queries) | |||
| Errors accessing shared speadsheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
