compatibility mode

  1. C

    Excel 2013 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...
  2. B

    Special Countif Function that I cannot figure out

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

    Compatibility checker - modify default selection?

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

    Compatibility Mode Issues

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

    Stuck in compatibility mode (Excel 2007)

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

    excel 2010 64bit and file sizes and compatibility

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

    compatibility mode and new file creation

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

    Grey Out Issue

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top