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

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top