Solved

Strange Excel Copies

Posted on 2011-02-26
4
241 Views
Last Modified: 2012-06-27
I have a folder on a 2003 Terminal Server with about 40 Excel files in it.  Using Office 2003.

I have remote users logging onto thes files to update them. The excel file has some VBA code

From time to time these files somehow create a copy of the files and it appears in the directory as typically C138EFA0. It is an Excel file, but does not have the xls extension and is listed as type files  - attributes A

What is going on.
Do I need thiese files
How can I stop then appearing
Can I make them appear in another folder and use them as backups?

Thanks
0
Comment
Question by:jontyplatt
  • 2
  • 2
4 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 34987210
When Autosave is enabled Excel create a backup copy of the file while the file is in use so if any problem occurs Excel can rebuild the file using the backupcopy. Sometimes errors do happens and Excel creates these files especially when the file has been closed forced like CTRL ALT DEL or some other faults.

To see if these files have meaninings you should try and do the fiollowing:
1) Try to isolate what user is creating these files
2) When you locate the user try opening the the normal file from his/her computer, once you close it Excel will display a list of files asking you if you still need them ... if not needed then choose the option to remove them (Excel prompt for 2 choices)
3) Examine the Security rights (user rights for this user on the files) maybe insufficent user rights creating these problems.
4) Are several users accessing the same file simultanousely ? if yes maybe that is what is creating these backup files

Rgds/gowflow
0
 

Author Comment

by:jontyplatt
ID: 34987387
It would appear that all users are creating these files - but not me.

The users do not access the same files - the files are specific to each user.
0
 

Author Comment

by:jontyplatt
ID: 34987413
Actually I think I know what is doing this - the user permissions on the folder are set to rear write, but not to modify.

I dont want the users to be able to delete files or make new ones. When I log on as a Adminidtrator I have full rights.

Strange that Excel should be able to create a new files and then write ti to thie directory - any ideas?

Basically these files are teachers reports on their pupils and they add test to the cell in the Excel spreadsheet. The pupil's names are listed here and when the reports are fininshed they are imported into an Access database  
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 34988661
Well if you set the permission to write and not modify then you hv a conflict. I did not fully understand the purpose of the files and it seems you definitively hv a permission issue that is creating this problem.

Pls clarify what is the user permitted to do on the file.
As far as yourself to hv full administrator right youneed to have FULL CONTROL on the file with the username you logonto this file
Example if you login the machine and log as Administrator then the user should be Administrator on the machine to hv full access. If you login as administrator thru the network then you want this user administrator on the network to hv full rights.

Same thing for the users you need to make sure the user rights set on the file corespond to the user rights they use when they access the file (is it local or thru the network ?)

Finally one last thing if you want the users to hv access to the file but not able to delete them you need to make sure of following:
1) They do not belong to a group or being themselves Owner of the file
2) They do not belong to a group or be themselves having full access to the file
3) The file has been removed inheritance from parent object.

The best way to handle this is to remove all access to the file by unticking the inheritance check box in Securty/Property/Advanced and choosing Remove. Then hou hv no access whatsoever to the file. You start by adding yourself as administrator then you add the specific user with the limited permission making sure you do not click the Delete (Read,write etc ...) then accept.

Rgds/gowflow
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now