repair

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...

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...

I am having difficulty developing a formula that will pull cell data from a workbook sheet. PLEASE HELP – Looking for an Excel expert to suggest a formula. I receive a data dump in excel (stacked data). Here is a sample of what the columns of interest look like. The each row is the...

My Excel crashed and restarted. In the document recovery pane, clicking the most recent version of the file (a .xlsb file) opens a dialog box that says this version contains some repairs and prompts me to let Excel recovered as much content as it can. However, clicking yes simply leads to a...

Hi, I hope someone can help. I have a macro enable sheet which allows me to tick off order numbers as i go. Each number highlights green with red text so that i can see visually alongside the tick which numbers have been used. This was working fine on Excel 2007, but i started having massive...

Hi guys, For some reason this morning I am getting this message when I try to open my workbook; "Excel found unreadable content in 'Para Reg.xlsm'. Do you want to recover the contents of the workbook?" -> click ok "Excel completed file level validation and repair. Some parts of this workbook...

Dear all, Virus encrypt my all excel files now i am unable to access them is anyone know how to repair encrypted virus files. i think its chines virus. if anyone know then please share. Thanks in advance.

Hi guys! I’ve been reading the forums for a few months, but this is my first time posting. I’m pretty new to VBA, and I’ve been trying to figure this one out for days. Basically, some data with long descriptions is pulling back broken into Excel, and I need a way to repair it. The data pulls...

I am working on an excel spreadsheet which has a large amounts of arrow (using the excel drawing tools). To open the file excel needs to remove the drawings tool images I have used. This sounds trivial but they are an important part o my document. I am using excel 2007 and windows 7 1) can...

I have an Excel template which, before applying the formulas to fill the charts, tables etc. doesn't give any hint that there's something wrong with it. However when I export it with actual values it gives an error, saying the following: Excel was able to open the file by repairing or removing...

Hi all! I found a lovely little formula to help me search a list for a keyword or number and then return multiple matching results to populate a dropdown box. It worked brilliantly, but, unfortunately, in all my machinations I ended up breaking it. Now, I don't know what goes in the space that...

I have the following VBA code to compile dynamic ranges in a certain tab into single data validation lists in other tabs. The macro works when I open the Excel file but I'm forced to do an "Open and Repair" each time, is there something I can change in the code to fix this? Please see below...

Hello Excel Wizards, I have a template I have built up over the years. It started as a fairly simple workbook but over time the calculations and functions have become more and more complex. Recently, the files saved become corrupted--not all the time, but more frequently than ever before. I...

I have a file that I have been fixing up with lots of Names so the formulas are easier to read. There are 12 sheets (sept-aug) and a summary sheet. Each month sheet has a table. I close the doc and when I opened it I got an "unreadable content" error. I let if fix things and it opens the doc...

Hi Everyone I have 6 corrupt excel files, started with one not closing properly and then subsequent files I tried to open. This is what I have tried so far without success:- 1.Follow microsoft recovery suggestions 2.Attempted to open in workpad, star office etc 3.Tried demo versions of...