Recovering Lost Excel Work

Jan 12, 2013

I have been working on some files in excel for several days, saving regularly, etc. but have run into a huge problem. I was marking cells with a background color to organize and track my work, but the files being saved were .csv's.

From my research, it seems that .csv's only save data, not formatting such as cell background colors.

However, while I was working on the files, they displayed the colors correctly etc.

I am hoping that there is some sort of temporary file created by excel that would allow me to re-open my work and have the coloring appear so I can save the work as an .xlsx file with formatting.

View 1 Replies


ADVERTISEMENT

Excel 2007 :: Recovering Missing Worksheets?

Aug 29, 2012

I'm a novice using Excel 2007 at work and some of my worksheets have vanished.

On Friday I opened up an existing single-sheet workbook; while I was working on it I renamed the original sheet and added two new sheets. Obviously, I saved everything before I shut the file.

Today I've opened up the workbook and the two new sheets have vanished. Strangely, the original sheet has reverted to its original name (also the name of the workbook), but the changes I made to the data on Friday remain. The Properties window indicates there is only one sheet in this workbook, and confirms that the last save was made at the end of Friday.

The workbook is saved as an Excel Comma Separated Values file. I don't know if this is relevent.

View 2 Replies View Related

Recovering Changes In A Read-only Document When Excel Crashes

Aug 2, 2009

When an Excel document crashes, I get the option to recover the document the next time I open Excel. However, if it is a read-only file, I don't get this option.

Is there any way around this? I usually work in read-only documents, saving my changes to new documents. If the read-only file I'm working in crashes.

View 6 Replies View Related

Excel 2010 :: Recovering Username On Specified Cell

Oct 4, 2013

Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _
(ByVal lpBuffer As String, nSize As Long) As Long

Public Function UserName() As String
Dim Buffer As String * 100
Dim BuffLen As Long
On Error GoTo UNerr

[Code] ......

I found the code online and attempted to call the user name using =username() on the specified cell, but I receive the #NAME? error. I looked around and found several references to check the VB refence box for anything missing and I did not find anything incorrect.

To note, I am attempting this at my job's PC which will be used on other employees PC's as well.

View 6 Replies View Related

Excel 2007 :: Running Second Macro Causes Formatting To Be Lost

Feb 3, 2013

Running Windows 7, Office/Excel 2007

I have a macro which performs some conditional formatting on a worksheet. Based on the value in cells in one column, if the value meets the criteria some simple formatting is performed (row is colored, font changes for that row etc).

The macro then calls a second macro which performs the same evaluation on the same cells from the same column. If the value meets the criteria (same as previously) it is supposed to change the value of the cell by 1/2.

Both macros work, however the 2nd macro also seems to remove all of the formatting, font changes, coloring etc that occurred from the first macro. I have had the first macro save the active workbook and close and have the 2nd macro re-open the file but it sill overwrites the formatting. If I do not have the 2nd macro run the format changes are saved. I have tried saving the file after the first macro runs with .xls and .xlsx extension and no luck.

View 3 Replies View Related

Excel 2007 :: ID Number Formatting Lost After Text To Columns Is Used

Jul 16, 2014

I have a text file that I need to open in MS Excel 2007. The file contains the following data. (Each column is delimited by the "|" character.)

Part #|Inventory ID
1743|213,221
1864|10,40
1948|1170,1180
5265|100,104,107,10004

Ultimately, I need three columns but the data needs to look the same as it did before I opened the file.

When I open the file for the first time, I use “Text to Columns” to delimit the fields by the "|" character. The problem is that the Inventory IDs in the middle column get a bit whacky.

Here's what I'm left with:
Part # Inventory ID
1743 213,221
1864 10,40
1948 11,701,180
5265 10,010,410,710,004

The comma is retained appropriately when there are two 2- or 3-digit Inventory IDs.

When a row has multiple, longer Inventory IDs or Inventory IDs that vary in length, the comma is moved to every 3rd decimal place.

I tried putting quotation marks around the data before I opened the text file for the first time but that didn’t do anything. I tried Custom Formatting to retain the comma position (0000,0000) but this only worked when I had two 4 digit IDs. I also changed the number type to Text and General. Once the comma was changed, I couldn’t figure out how to get it back.

How to best retain the format of my Inventory IDs.

View 6 Replies View Related

Excel 2007 :: Chart Series Reference Lost On Save

Mar 17, 2009

I'm having a problem with named ranges in a chart. I'm using Excel 2007 in Windows XP.

I have a line graph with twenty different series all using dynamic ranges. I created each series individually, typing the name and then the dynamic range I had previously defined. As far as I am aware, Excel demands when writing the reference that you specify which sheet/workbook this named range is from, so, given the scopes of my ranges are all 'workbook', I added the name of the workbook to the references.

e.g.

Series name:
Series1

Series values:
='workbook name'!range1

This seems to work fine, but when I save and then re-open the file, the dynamic ranges no longer work. If I go to Select Data and look at the reference for a series, it has been changed thus:

Series values:
=[0]!range1

View 2 Replies View Related

Excel 2003 :: Lost Menu / Toolbars And Scroll Bars In All Workbooks

Nov 18, 2011

I was working on an Excel 2003 workbook with 3 worksheets. The first sheet is the 'Menu' sheet on which I placed buttons to take me to the other two sheets and back. I wanted to hide the Excel menus, toolbars, scrollbars, etc. on the 'Menu' sheet so that no user can alter that 'Menu' sheet. The 'hiding' code was not meant to affect the other two sheets.

The code worked fine. However, when I closed the workbook and tried to open a NEW workbook so that I could do some other work, I realised that the new workbook and its accompanying sheets had the menus, toolbars, scroll bars, etc. hidden. I closed the workbook and tried opening a new workbook. It was the same experience.

I called up the file with the code, deleted all the codes attached to that file, and re-saved the file. It did not solve the problem. And when I tried many more new workbooks and got the same problem, I deleted my entire Office 2003 installation and re-installed Office 2003. It still did not solve the problem.

View 9 Replies View Related

Recovering Values In Worksheet

Jul 13, 2008

I need to get the max value that is calculated in column g and then get the value associated with the max value in column e. I will then need to do calculations with them but that is easily taken care of. The code that I have for finding the max value currently is:

View 10 Replies View Related

Excel Pallet Lost Colors (hovering Displays Colors But Visual Clues Are Not Shown)

Jul 7, 2013

My pallet lost color-coding - if I hover over each little scare it displays the names for the colors and if I click on them they color the cells with the right colors, but the palette itself lost the visual display of colors except for 8 colors: black, blue, red, magenta, yellow, cyan, and white.

I use color-coding of cells a lot and I find it difficult to work without visual clues. At least the hover-support allows me to get the work done, but with difficulty.

View 12 Replies View Related

Excel File Too Large To Work

Feb 24, 2013

I've been having tremendous issues with my Excel file, mostly with it crashing or not responding. Would this be because my file has so much data in it? If so, is there anyway to make Excel process all the data without crashing so much?

View 6 Replies View Related

Adapting VBA From Word To Work In Excel?

Jan 26, 2014

I have been using a macro in Word created from pieces all over the internet (credit to a user named matt198992 for recursion script). The code prompts a user for folder, then runs a macro called Publish as PDF to all word files in the folders/subfolders.

I want to adapt the code in Excel, but I am having trouble. Error on the line "Workbooks.Open Filename:="Path & DirN".

[Code].....

View 10 Replies View Related

How Can I Get Excel To Work Out My Hours And Overtime

Jan 31, 2009

I charge 45 per hour with a couple of conditions - minimum 8hr day and then 1.5T after 12hrs.

Is it possible to have a table where I put in my hours and then Excel tells me how much I should charge?

View 9 Replies View Related

Excel Autofilter Does Not Work With Renamed Cells

Apr 4, 2013

I have renamed some cells to custom names eg. renamed cell A1 to FLIGHT and B1 to FLIGHT2.

When I apply a filter to the columns and autofilter, the renamed cell now refers to a different cell! ie. FLIGHT no longer has the same text value in it

This also only happens when I autofilter by alphabetically or highest/lowest values

View 1 Replies View Related

Hypertexting Within Excel Not Work In Pdf Saved File?

Dec 15, 2013

I have this excel file that is 17 sheets long and I made a table of contents page so it is easier for people to navigate. I know my hypertext links in my file are correct because it works when I click on the hypertexted cells, my excel file jumps to the respective sheet.

However, when I save the file as a pdf the hypertext links do not work. how to get my table of contexts to jump pages in a saved pdf file?

View 3 Replies View Related

Excel 2010 :: For Loop And VLookup Don't Work

Aug 21, 2014

The for loop don't work in my excel 2010 macro. Probably the problem might be the Range("Fi") construct with the variable "i"?

Dim i As Integer

For i = 4 To 10004
Cells(i, 63).Select
Cells(i, 63) = Application.VLookup(Sheets(3).Range("Fi"), Sheets(4).Range("F:AY"), 45, False)
Next i

View 3 Replies View Related

How To Make Excel Template Work On Only 1 System

Mar 9, 2014

Is it possible to make excel template work only on 1 computer by giving any vba password (on lines of license number).

Aim is to ensure it works on only client computer, even if template is shared outside it becomes useless.(We often see clients audit team getting access to templates using it for thier purpose & distributing).

In same spirit what are best practices one can take like protecting formulas with password etc

View 3 Replies View Related

Excel 2007 :: Speak Cells Command Do Not Work?

Feb 17, 2013

I am using Excel 2007 Enterprise edition and want to use speak cells command (Text to speech in 2003).

I have added the command for these in quick access tool bar but when i press any of these buttons, all the buttons of this category disabled.

Using windows 7 Ultimate

View 1 Replies View Related

Excel 2010 :: Freezes Or Hangs In The Middle Of Work?

May 24, 2013

I have an issue with the excel freeze in our organisation.

Our organisation works on Citrix and the office applications have been upgraded to 2010 very recently.We have both 2003 excel users and 2010 excel users.There is a user who has a problem working on excel 2010 the excel freezes.Excel 2010 works fine for some time and all at a sudden hangs,once its hung it freezes all the other applications.

The same file runs properly on the other 2010 systems.The Excel file which hangs are also not of huge in size.

I am unable to get to the rootcause of the issue why the excel freezes or hangs in the middle of the work getting to the root cause of the issue and an answer for the excel hanging.

View 3 Replies View Related

Excel 2007 :: Macro Doesn't Work For Certain User

May 7, 2014

I have created a macro that a couple of us can run at the end of the day that looks in a preset folder and has whatever .xlsx files in that append to each other creating one .txt file. It then saves that .txt file and runs a batch file that strips off the .txt file extension. This is the format we need the ending file to be in so we can FTP it to another agency.

Myself and another coworker can run it without any problem and it asks us if we want to save the .txt file before it closes it and runs the batch file stripping off the .txt extension. We say yes and it executes as designed. Another coworker runs it and it looks like the files are appending then the window closes. Never prompts him if he wants to save and the file is nowhere to be found. From what I have researched all his excel settings match ours. We are all running the same OS (XP) and version of MS Office (2007). The part of the macro that seems to just be ignored is below:

[Code] .......

Then the following batch file runs stripping the .txt file extension:

FOR /R "T:Cash ManagementUnsecured\_Team - DisbursAUTOMATIONInput" %%f IN (*.txt) DO REN "%%f" *.

I have tired removing the ActiveWorkbook.Save command thinking it would default to prompt him to save it but it doesn't.

View 2 Replies View Related

Create Work Breakdown Structure (WBS) In Excel Automatically

May 25, 2014

How to Create a Work Breakdown Structure (WBS) in Excel automatically with given data through macros.

In the attached excel sheet

work_breakdown_structure_.xls

Is there any way to do it for data automatically?

View 1 Replies View Related

Excel 2007 :: Creating Workbooks With Macros That Work On Other PCs

Apr 20, 2012

I have written a 2007 workbook which contains 4 simple macros. One of the macros automates the process of saving the print range as a .pdf file. It works fine on my pc but when I send it to others to use, when they try the macros, they all return a 1004 runtime error.

View 6 Replies View Related

Minimize Windows And Allow Other Excel Work Books To Open

Apr 30, 2012

I have created a userform template and is working fine, the problem is the users are not able to minimize the template nor open any other excel files.

How to allow the template to open any other excel files or macro enabled files and also to minimize the windows.

View 1 Replies View Related

Excel 2007 :: Hyperlink Not Work With Cell Protected

Oct 24, 2012

Excel 07

I inserted a hyperlink into a cell that goes to a web page. It works when the sheet is NOT protected, as soon as I protect the sheet it stops working. How do can I lock the workbook and that cell so nobody can change it but the hyperlink still work?

View 2 Replies View Related

Macro To Add Excel Attachment In Outlook Doesn't Work

Jul 31, 2013

i have a macro which i have created to send outlook notification email through excel 2010 when the excel file is saved. I would like to attach the same excel file as an attachment in the outlook email so that everyone in the mailing list can view the attachment. however the macro which i created does not work. i would like to know what is the problem with the macro below. there's an error which says "file path does not exist" when i try running the macro but i have verified my filename is correct & the drive i have saved the excel file is in Z: drive. My file name is 'Tracking File.xls'

'Save Workbook
ActiveWorkbook.Save
'Criteria to send Email

[Code].....

View 1 Replies View Related

Excel 2003 :: VLookup Doesn't Work But Cell Seem To Be The Same

Oct 16, 2013

I am having difficulty with a Vlookup in Excel 2003. Basically I have converted both fields to Text using the text function =TEXT(A2,"0") and have tried matching the values but just get an #N/A error and I have also converted both back to number format but still get the #N/A error....when I do a "=" operator function it returns a FALSE value but I cannot see why as both cell are just 4 or 5 digit number.

View 3 Replies View Related

Excel 2010 :: Formula That Will Work With Text And Numbers?

Dec 10, 2013

I am working in Excel 2010 (Windows 8) and am having real problems trying to find a function/formula that will work with both numbers and text. I am trying to identify if the contents of Col A cells and Col C cells on each row are duplicated within a worksheet, and if they are, to add a 'J'.

(Column A is a list of numerical company codes and Column C is a list of adviser codes using the letter A-G. If a company ID code has more than one of the same adviser codes referenced to it, it is termed 'Joint', hence the 'J').

The formula I've used is: =IF(A2:C2, FREQUENCY>1, "J")

But it tells me 'numbers only'.

View 4 Replies View Related

Work Out A Formula For My Spreadsheet Which I Use To Work Out Cutting Lists For Timber Frames

Jan 11, 2009

i need to work out a formula for my spreadsheet which I use to work out cutting lists for timber frames. I need it to work out if the width of a job is for eg 2400mm i need to work out how many timber studs I need so the space between each stud is between 400mm and 500mm and this will need to work for a range of different sizes of frames. I have it written at the moment and it just devides the width by 400 and gives me a amount of studs but it would work much better if it could space them between 400 & 500.

View 4 Replies View Related

Work Accurately With Times To Calculate The Work Progress Of The People In The Workshop

Mar 3, 2009

In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes....

I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected.

From monday to friday the workmen log their times as a start time and a end time. This has to be then calculated to a total hours:mins spent per job, wich in turn then has to be calculated to a total hours:mins spent per day. And the on the complete week sheet recalculated as a total time worked per week.

View 9 Replies View Related

Excel 2003 :: Translating Remove Duplicates Function To Work

Oct 16, 2013

I've been left with a macro built in 2010--but I need it to run in 2003.

I've identified a Remove Duplicates function as the cause of a bug, how to translate this to a 2003-friendly macro? This will be an action in a much longer macro. What I am trying to do is check for duplicates in a particular column (Column C), and remove any duplicate row (it doesn't matter which duplicate is removed).

VB:

'Remove duplicates
Sheets("Input sheet").Select
ActiveSheet.Range("$B$4:$H$2005").RemoveDuplicates Columns:=3, Header:= _
xlYes

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved