Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Unprotected Excel File Issue


  • Please log in to reply

#1
Joriee

Joriee

    New Member

  • Member
  • Pip
  • 1 posts
We have a shared Microsoft Excel 2010 workbook on a drive at work. 2 times now someone has been updating this workbook and when they went to save and close, the file was removed from the drive. The first time, the file had been left open on someone else's computer from the previous shift so we were able to recover their edits but lost ours and had to update again. The file was lost from the drive again tonight when someone tried to save and close after editing but the file cannot be located in any of their documents or anything like that. I'm trying to figure out what, if anything this person is doing wrong because the file isn't even in the recycle bin as if she deleted it; nor can I locate it anywhere else on her computer or if this is some issue because the workbook is unprotected and multiple people can be on it at once. Anyone have any ideas or solutions?
  • 0

Advertisements


#2
Makko

Makko

    Freshman

  • Member
  • PipPip
  • 23 posts

Perhaps multiple people have the file open?

Then person A who has been editing saves the file at say 4pm.

Then person B exits (who has had the file open but made no changes), it asks to exit and 'save changes' at 4:05pm and they click yes?

 

A good alternative is using google docs which has a spreadsheet option. Here people can view and edit documents online in real time. Also, other people can see in real time the changes being made. Might be worth a try.

 

Google Sheets: https://www.google.c...u/sheets/about/


Edited by Makko, 16 February 2017 - 03:45 AM.

  • 1

#3
Dazy Parker

Dazy Parker

    New Member

  • Member
  • Pip
  • 2 posts

We have a shared Microsoft Excel 2010 workbook on a drive at work. 2 times now someone has been updating this workbook and when they went to save and close, the file was removed from the drive. The first time, the file had been left open on someone else's computer from the previous shift so we were able to recover their edits but lost ours and had to update again. The file was lost from the drive again tonight when someone tried to save and close after editing but the file cannot be located in any of their documents or anything like that. I'm trying to figure out what, if anything this person is doing wrong because the file isn't even in the recycle bin as if she deleted it; nor can I locate it anywhere else on her computer or if this is some issue because the workbook is unprotected and multiple people can be on it at once. Anyone have any ideas or solutions?

Joriee,

 

Deleted file goes into recycle bin if, you delete it from your local machine. In case of shared network, you can recover the deleted file. Follow these steps to do so,

 

  1. Open the shared network where you had the Excel file.
  2. Right-click on the blank space and choose the Properties.
  3. Now click on the Previous Versions tab.
  4. Check the deleted file and restore it.

I hope it will work for you.

 

Good Luck!


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP