There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
acer black screen boot computer connection crash css dell display driver drivers email error ethernet excel explorer firefox firefox 3 freeze game hard drive internet internet explorer itunes laptop linux malware monitor network networking nvidia outlook outlook 2003 outlook express partition password printer problem router slow software sound trojan usb video virus vista windows windows xp wireless
Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Excel: Unreadable Content


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
java_momma's Avatar
Computer Specs
Senior Member with 160 posts.
 
Join Date: Feb 2003
Location: New Jersey
Experience: Advanced
18-Jul-2008, 12:25 PM #1
Excel: Unreadable Content
I am ready to burst into tears. I was working on my workbook on Tuesday. Added a sheet, hid another sheet and saved. Everything was fine. I opened it up yesterday to add to it and excel (2007) had an error pop-up that said, "Excel found unreadable content in "master.xls." Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes." If I click yes, only numbers appear every now and then on some of the pages. All the other information is gone. I had a ton of pages on this workbook. I closed it and didn't save changes. I opened it in Open Office calc and it was blank as well. The file itself is showing as 1.22mb. The thumbnail shows writing on the sheet.

Did I just lose all my work? (It would so fit in with the week I am having.)

Any help would be soooo appreciated.
Thanks.
Erin
Rollin_Again's Avatar
Distinguished Member with 2,872 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Brilliant When Sober
18-Jul-2008, 12:55 PM #2
Post the file or email it to me and I'll see if a repair utility will work on it.

Rollin_Again at hotmail dot com

Regards,
Rollin
java_momma's Avatar
Computer Specs
Senior Member with 160 posts.
 
Join Date: Feb 2003
Location: New Jersey
Experience: Advanced
18-Jul-2008, 01:08 PM #3
Quote:
Originally Posted by Rollin_Again View Post
Post the file or email it to me and I'll see if a repair utility will work on it.

Rollin_Again at hotmail dot com

Regards,
Rollin
Thank you -- file is on it's way to you. My email is erin.mycupofjoe at gmail dot com.
Rollin_Again's Avatar
Distinguished Member with 2,872 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Brilliant When Sober
18-Jul-2008, 01:50 PM #4
I ran the repair utility on the file but nothing but jibberish was displayed in the workbook. My repair utility is pretty old (5 years) so you may want to google "Excel Repair" to see if a newer program can recover your data. Most of those programs allow you to try the program with limited functionality to see if it works before deciding whether or not to spend the money to pushase it. Sorry I couldn't help more.

Regards,
Rollin
__________________
Protect your computer and keep it free of pests and other spyware. Download AdAware, Spybot, ZoneAlarm and lots of other great utilities at PC World / SnapFiles / Major Geeks, Tech Guy Stuff

Help Keep this site free by making a small donation

http://www.techguy.org/donate.html

tsghelp / support
java_momma's Avatar
Computer Specs
Senior Member with 160 posts.
 
Join Date: Feb 2003
Location: New Jersey
Experience: Advanced
18-Jul-2008, 02:01 PM #5
Quote:
Originally Posted by Rollin_Again View Post
I ran the repair utility on the file but nothing but jibberish was displayed in the workbook. My repair utility is pretty old (5 years) so you may want to google "Excel Repair" to see if a newer program can recover your data. Most of those programs allow you to try the program with limited functionality to see if it works before deciding whether or not to spend the money to pushase it. Sorry I couldn't help more.

Regards,
Rollin
Well thanks for trying!

I'm bracing myself for the worst. Hopefully I can build back most of it. Some I know will be lost for good. :S

Thanks again!
slurpee55's Avatar
Computer Specs
Distinguished Member with 4,273 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
18-Jul-2008, 04:02 PM #6
try the steps listed here
http://support.microsoft.com/kb/929766
java_momma's Avatar
Computer Specs
Senior Member with 160 posts.
 
Join Date: Feb 2003
Location: New Jersey
Experience: Advanced
18-Jul-2008, 04:19 PM #7
Quote:
Originally Posted by slurpee55 View Post
try the steps listed here
http://support.microsoft.com/kb/929766
Hi! I have no clue in the world what that is talking about. :S I don't know how to remove the current time properties. Thanks though! I'm doomed. I know it. :|
slurpee55's Avatar
Computer Specs
Distinguished Member with 4,273 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
18-Jul-2008, 04:52 PM #8
This happens when excel has a pivot table that connects to a SQL Server Analysis Services 2005 cube with defined KPI's where at least one of the KPIs have set property "Current Time Member". To fix this problem you have to make sure that "Current Time Member" property does not have anything defined in it. - Alas, I really don't know what the heck it means either. I have read that if you fix the KPI, you should refresh all the Pivot Tables, save and then open again and it should be okay.
Anyone understand this?
__________________
Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime.

My theme song...
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who help people like you solve computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 10:21 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.