• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel error that can not be opened

D

dongsapaseo

New Member
I am having an excel error that can not be opened, but when i click yes all the formulas and formulas are gone
upload_2018-7-25_13-23-24.png
Who can help me?
 
Are you saying that you don't keep incremental back-up copies of your important files?
 
Oh dear, oh dear, oh dear!!!

Attach the file here - maybe one of us can open it for you.

In the meantime, set yourself up a back-up system for the rest of your important documents before this happens again. :)
 
Are you not able to attach the file directly here using the Upload a File button?

Your link is giving a "File does not exist" error message.
 
It opens in protected mode, but I cannot do anything else with it - it crashes my PC. I think you will have to start again. There are free utilites online that CLAIM to be able to recover damaged files - maybe try one of those? Why had this file become so very large?
 
I repaired it, but there are missing references in many formulas. I've changed it to binary file format to reduce size.
https://drive.google.com/open?id=10InVd0GBioENzbLOdpnXYmEHkclWOztJ

Looking at your workbook... I'd suggest you start from scratch and redesign your workbook. Few of the sheets looks like Copy Paste Values result from multiple pivot tables.

Depending on version of Excel. You may want to consider using PowerQuery & PowerPivot to accomplish your end result.
 
AliGW said:
It opens in protected mode, but I cannot do anything else with it - it crashes my PC. I think you will have to start again. There are free utilites online that CLAIM to be able to recover damaged files - maybe try one of those? Why had this file become so very large?
Click to expand...
This file is an inventory file, so make this file easy to manage
 
Yes, and ...??? How much data does it contain?

A corrupted file is not easy to manage, though, is it? So you need to start making incremental copies as you work on it going forward so that you have back-ups.
 
1. Each time you open the file, immediately save it to a new name (e.g. myfile_27.07.2018.xlsx) so that you have a back-up before you start working (this way you are not constantly overwriting your files).
2. Get into the habit of archiving your older file versions to some form of back-up storage (e.g. cloud and/or external hard drive).

I have automated all this using some free back-up software (I will not name it here, as that would be advertising, but there are several options if you Google). My laptop backs up over the home network every moring when I log on, so that my PC and laptop hard drives are synchronised. My PC is set to back up overnight to two external hard drives and to cloud storage, so I have three copies of my data as back-ups, plus the two synchronised hard drives. This means that if anything goes wrong during the day, I can restore lost data from one of my overnight back-ups. Why cloud storage? Well, my house might burn down.
 
Oh really bad, but if using the cloud to create backups, the cost is high when you need to store more data for each account.
 

As the worst is to not have any backup !
Whatever the place, a cloud, an external hard disk …​
 
dongsapaseo said:
Oh really bad, but if using the cloud to create backups, the cost is high when you need to store more data for each account.
Click to expand...

It's not that expensive! However, if it's a problem, then make sure that you keep one of your external back-up drives off-site, maybe at work. Bring it home to back it up once a week (and hope that your house doesn't burn down on that day!). There are several ways to skin this particular cat, but as Marc has said, the worst thing you can do is nothing at all: I started backing up just one week before my first PC crashed and the hard drive could not be fixed. Had I not started backing up, I would have lost thousands of photos of my daughter growing up. I was the lucky one. ;)
 
You must log in or register to reply here.
Back
Top