compatibility mode

Morning, Acolleague has sent me an Excel Spreadsheet which was in compatibility mode.This has converted it to Excel 2013. The problem is that 8 rows at the top ofthe spreadsheet which were not previously viewable are now fully on display andwhatever I try to do to hide these rows it doesn’t...

Hello, I have a worksheet for demand planning and forecasting that basically shows: <tbody> Stock Monday Demand Tuesday Demand Wed Demand Thurs Demand 10 4 5 4 3 </tbody> I need to write a formula that will tell me how many days my stock will last (ie: how many days, after fulfilling that...

Hi, I'm trying to figure out if there's a way to change the default for the Compatibility Checker "Select versions to show" drop-down list (i.e. 97-2003, 2007, 2010). When running a compatibility check in a large workbook with lots of pivot tables, the compatibility checker can take quite a long...

I am receiving very large excel .xls files produced by Crystal Reports. These files all contain more than 150,000 lines. I have to open the .xls file in compatibility mode I know, but then, after I run Convert, the resulting file still only has 65000 lines. I close and reopen the file as an...

I know how I am supposed to be able to exit compatibility mode -- save as an Excel 2007 file. But that is most definitely not working, and my problems seem to be greater than that. Here is the history of how I got here -- please help if you can! (1) I open an Excel 97-2003 document. (.xls...

I have 64 bit windows ultimate and 2010 excel 64 bit... I have a program that exports data (approx 777,343 rows of data) in standard .xls format.... when i open it in excel, i can only see 64k rows and am in compatibility mode... Does anyone know how i can view all 777K rows? thanks

I have an .xls file (compatibility mode) containing about 40 worksheets. My goal is to save each worksheet as a separate workbook. To do this, I turned to David Mcritchie's macro, found here: http://www.mvps.org/dmcritchie/excel/saveas.htm I run this macro in Excel 2007. It works, but I get the...

I just took over a new job and they have a database in Excel 2007 Compatibility Mode that they want a sheet protected. However, the sheet protect and a myriad of other functions are greyed out. I have tried everything to get back these functions, but they seem to be locked out. The old system...