repair

  1. J

    File Format Not Valid; Document is corrupt- Need help repairing

    I have an excel document that is corrupt and I cannot repair. It simply as Excel cannot open the file because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format file. I have tried a lot of the simple...
  2. D

    IF AND Statement

    Hello, I am trying to create a tool which dependent on year, will tell me whether to upgrade a phone or repair. I have go to it work with the year so that it either returns "repair and Replace" dependent on year... but i want to incorporate an and statement in this. the statement below is...
  3. K

    Excel Repair Tool / Recomendation

    Does anyone have any unbiased recommendations for an Excel Repair tool. I don't mind paying for a good tool but it seems like if you google Excel repair tool the results are mostly promoted reviews and not unbiased. I have some xlsm workbooks that crash from time to time so what I wanted to do...
  4. K

    Pivot table; show values as percent and total as number

    I have a pivot table with a list of different types of events in the first column (row labels), e.g. boiler repair, floor repair, window repair. The value columns are the days of the week, with the number of each type of event (repair jobs) occurring on each day. I would like to show the grand...
  5. R

    Count after finding a Word within a Cell

    Hi, I am hoping that someone can help to find a solution. In the example text below, what I trying to do is find the words: Bas, Maj & Repair, when I do this using the formula below it returns the number of times that the word appears, however, what I really need to do is to count the number...
  6. baitmaster

    file corrupting when saved

    I have a large and complex file currently open and working. I've been saving regular versions v1.1, 1.2 etc throughout the day. When I attempt to reopen any of these I'm getting the error "we found a problem with some content in ..blah blah.. do you want to repair?". The repair tool doesn't work...
  7. welshgasman

    White is the new Yellow

    Hi all, Posted here on thread https://www.mrexcel.com/forum/excel-questions/1078016-what-am-i-missing-again.html and got to the bottom of that problem. Solved it by using the Round() function. Now my sheet and not even the affected rows does not show values > than a cell value as yellow...
  8. S

    Moving rows automatically based on cell value

    Hi, I want a macro to move a row based on the cell value into a specific sheets. I have two questions and would really appreciate your help. Especially the second is important. 1. If status is "Ready for Repair" move to Sheet "Repair" and so on... The following macro is working but I would...
  9. E

    Copy coloured cells to another spreadsheet

    <tbody> ROUTINE MAINTENANCE Bus No Job No Type ins VOR 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y 12345 NE TYRE REPAIR Y Y </tbody> If the above...
  10. P

    Excel VBA to Compact and Repair

    I have seen a lot of threads on compacting and repairing a dB from excel. I have not been able to get anything to work properly. I have the below code....Is there a way to get the compact and repair to work after I delete the data in my tables? Sub accessMacro() Dim appAccess As...
  11. C

    Convert 2nd column values to rows when column 1 is the same name

    I have 2 columns Column 1 is the name of a street and that street name is repeated for each task that was completed on the street. I want to group the street name so that there is only 1 line but a new column for each task 10th street Repair pothole 10th street New Stop Sign 10th street...
  12. F

    Excel's repair

    I have created an excel file using 2007 (xlsx) version. I gave it to some friends to use it who are using later versions and they are getting that file is corrupted and excel is trying to repair it. When it is repaired some of formulas at conditional format are gone and the whole functionality...
  13. Z

    office16 installation

    Respected, was showing Error code 0-1012 (0) So as per microsoft recommendations disable 1)Antivirus 2)firewall 3)empty temporary files 4)Make mare diskspace(previously was 148 GB , now is 162 GB) Now only one issue is left , repair registry(and that needs reinstalling which is a very...
  14. M

    File is corrupted when trying to open in O365/2016 but works in Excel 2010? **!

    I restarted my computer recently, and it had been a while. Now, when opening my excel file, O365 thinks it's corrupted. Upon trying to repair it, all the charts from one worksheet are no longer present. This worksheet had about 200 charts, and they are now all gone. The funny thing is, the...
  15. B

    multiple cells to check - different output

    Hi, i am quite new to the excel world and i was asked to help our field service team. basically I try to make a kind of a cheat sheet - to let our team understand what they should mark and what they should not mark. I need to check two fields. Named as "Work" and the second is "Billing" each...
  16. W

    Status Update on Worksheet Lookup on other Worksheet

    I have a repair database that when I put in "Waiting for Parts" status (Column I), I will look up the repair ID (Column C) in [Parts Worksheet], and look if there is a match. If there is a match, it puts the same ID in Column A. This lets me know that I have a part inputted for the repair...
  17. M

    Spreadsheet Formulas/Layout

    https://imgur.com/a2wvVav I'm trying to create an equipment log to monitor our facility's equipment and their various conditions. The imgur link is what I have so far. If anyone can suggest a cleaner layout, I'd be open to it. Number of Repairs-I'd like to color code each cell in this column...
  18. K

    Conditional Formatting row by last column in row value

    Wise people of the forum.. I need help. How do I Conditional Format each row separately to show the locations that exceeds the average of all locations in the row? Once it set up for the first row how do I copy it down to the remaining rows? <tbody> Location 1 Location 2 Location 3...
  19. B

    Missing buttons

    Hi, I tried searching but couldnt find what I needed. I have missing buttons from the ribbon in Excel 2013 (Shown Below). It's happening for all my spreadsheets. I have tried the following and still have no luck - Repair office 2013 - Add / Remove Excel - Uninstall and reinstall Office...
  20. B

    Populating a cell based on conditions of other cells

    I have a small test spreadsheet similar to one I use at work where I'm testing out some things and trying in a number of columns to populate cells based on conditions of other cells to cut down on the amount of inputting needed. I have the basic formulas figured out, and it's all working...

Some videos you may like

This Week's Hot Topics

Top