I was using solidworks and a datatable, which is just an excel file, got corrupt.
I killed solidworks in the middle of the process and chances are it didn't get finished updating the file.
In any case, I opened the file and I see some of the data but it is not compressed like the other excel files of similar data. It seems to be a raw binary excel file(not xml) and has some readable text and cell values.
Is there any way to recover the data? I'm sure it's there(it may be partially corrupted or just may not be in the correct binary format that excel is expecting.
I have a client who has a very complex Excel file with lots of Visual Basic programming. The file has been corrupted somehow, and he doesn't have a backup. Needless to say, he is now a strong proponent of backing up on a regular basis.
He's tried downloading trials of a couple Excel recovery programs, but no luck. He even sent the file to a company who made one of the recovery programs, and they said the file was unrecoverable.
An excel workbook we have on a shared drive is returning an error message: "The document is corrupt and cannot be opened. To try and repair it, use the Open and Repair command in the open dialog (File Menu) and select extract data when prompted. I am having trouble following those suggestions, Open an Repair doesnt' seem to be an option on the file menu. I have Excel 2003, is there any way to recover our workbook?
One of my excel files has refused to open and i think it is corrupted. The error message is; Excel cannot open because the file format or extension is not valid .Verify that the file has not been corrupted and that the file extension matches the format of the file.
How do i repair and recover all the data in the excel file.
I have a excel file which is corrupt. The message show" The file may be read only, or you may be trying to access a read-only location. Or the server the document is stored on may not be responding". I want to know is it can recovery it or not. I have use many software and still can't fix it.
tried to save the file, the only message I received was, "File did not save" so I tried accessing my macro, and on opening VB got another error message, "Error Accessing File. Network connection may have been lost."
came to the conclusion that the file is corrupt. I could not determine if there was an easy way to recover it. I do not have a backup that I can use. I've never had a file simply corrupt
The macro itself works fine, which to me signals that the file isn't actually corrupt.
I was working on a tax file yesturday, just a long long list of receipts. and the file is password protected. However, I went to open it today, and I get a message that says: "Filename.xls cannot be opened. the file may be read only, or you may be trying to access a read only location. Or, the server the file is located on may not be responding."
It's on my USB Drive. I've tried copying it to my HD so I can play with a copy, but no dice. When I try that, I get another error message, : Cannot copy Filename.xls. The file or directory is corrupted and unreadable. I've tried the various fixed suggested in the excel help files to no avail. I did a search on the forum, but didn't find anything that seemed to apply or help me. The computer I'm trying to open it on has Office 2003, the one I most recently worked on the file on has office XP. Not sure if this was a source of the problem. Doesn't seem like it should be. Hasn't been in the past. I'm not even getting to the dialogue box asking for my password yet.
I have a excel file having some data and also I am having PDF file having some data, now I want to match the data in the excel file with the data in the PDF file.
Can we match excel file with pdf files?, this for comparing the data in the excel with pdf file having the data. Is it possible to do it?
My workbook took my 3 three years to build. The current copy has become corrupt. Although I have previous copies that are okay, I would like to know if there is a way to recover from this given that i would, otherwise, lose about 4 days of work.
I have a file that has become corrupt! It wont open and have tried using excel to repair!
It has some really important details on it! I work for a cinema compnay and so will send you some free tickets as a thank you if you can help me or I can send you the file for you to fix?
Im really desperate - the file has some important info on it that is almost a whole months worth of planning!
While making a spreadsheet, I somehow deleted a much needed column. I didn't notice this until after I had made several changes and 'saved as' many times. Is there any way to retrieve this data? I'm not tech-savvy.
VBA coding for automatically saving an excel file as another file using the current date as part of the file name together with "32ga" as a constant add-in. I also what this macro to run at a particular time of the day let say 00:20hrs. The excel file i want to save as is always open . It has data that changes every 24-hrs.
I am trying to have the total (cell e78) from one of my own excel files automatically filled into a cell in a different excel file when the number of that file is typed into a third cell. i.e. if the total on Ticket 4126 in cell e78 is $4500, then when I type 4126 into the Ticket # cell on my seperate Invoice I'd like it to fill in the third cell under Amount as $4500. Is this possible?
is it possible to import just a portion of a csv file into my excel workbook? For example:
My csv file has data from 2010-2015. I want to somehow import only data between 2013-2015 from the csv file into my excel workbook every time I click refresh.
I cannot delete data from the source file because many other people are using the same file. Is there some sort of "SQL" for excel that makes it possible to trim csv file?
I'm working on creating a custom HTML report with javascript that I will be using to import in to excel to populate some graphs. Basically everything is working, except if I use javascript to show me a value.
When I use Import Data from Web via excel, everything gets imported except for the javascript part of the html doc.
An example of the html file (stripped down to nothing but 3 peices of data): [URL]
I need to exact some data from a file. I can open the file, but can't see any data of it. I am afraid I need to do some setting so that I can see the data, but I don't know what should I do
I am using Excel 2013, and I am following the example here: VBScript Scripting Techniques: Read Excel files without using Excel that reads in Excel data as an ADO record set to a classic ASP file using VBScript. I am not able to import all the Excel data successfully, and I need to know what I'm doing wrong. Note that in all these samples cell A1 is the heading text "Column1" and the main data starts on cell A2 (consistent with the example code).
When my source Excel data looks like the following:
Code: Column1 1 2 3 4 5 6 7 X 9 10
It imports everything OK. However, if I move the X to the next row:
Code: Column1 1 2 3 4 5 6 7 8 X 10 ...the "X" cell gets imported as an empty string. So the imported array looks like this:
i have a fingerprint time recorder that provides me time log ins and log outs of employees which i use for the computation of their salaries every end of the week (saturday). here is a sample of the file i get from the fingerprint scanner program.
[URL]
now what i want to do is for it to consolidate all the names in 1 column, total number of days in another column, total basic gross pay in the next column and total deductions base on undertimeNAME Total number of work days total basic gross pay total number of hours deducted total deductions base on undertime
here is the table for salary deductions tardiness 08:01 - 08:30 am - 30 minutes salary deduction 08-31 - 09:00 am - 1 hour salary deduction 09:01 - 09:15 am - 1 hour and 30 minutes salary deductions 09:16 - onwards - considered as half day
undertime 03:35 pm = half day salary deduction 03:36 pm = one hour and a hlaf salary deduction 04:00 pm = one hour salary deduction 04:30 pm = 30 minutes salary deduction
