excel 2003 vs 2007

  1. R

    roll back excel 2007 macro to work on excel 2003

    hi all I have made an excel gantt chart using macros based on conditional formatting, in excel 2007. what I would like to do is use it on excel 2003 however I am struggling to rewrite the macros to allow approximately 70 conditions per cell with various colours. this is a sample of what...
  2. A

    Method 'ChangeLink' of object '_Workbook' Failed

    Hello, I keep getting the above debug error that I unable to fix. I am using some code to Change Links in Excel 2007. However the link I am trying to change is to an excel 2003 workbook. Code is below I am sure there is a smarter way to paste code but I don't know it yet. ''Successful change...
  3. L

    Translation of SUMIFS Excel 2007 Formula to an Excel 2003 compatible formula

    I am trying to translate the following formula into an array that will have the same function, but will be cross compatible with all versions of Excel. From what I have read online, you need to create an array in order to accomplish this. Does anybody know how to translate the formula below? I...
  4. D

    Macros in SharePoint

    Hi All, I have an excel 2003 document containing several macros on a SharePoint site. However, a user who recently switched over to excel 2007 reported that these Macros no longer work. This user doesn't get any error message and the VBA code for the Macros are still in the worksheet. Also, he...
  5. J

    Bob Phillips' CFMet VB/formula) returning #value error in 2007 that it didn't in 2003

    Hello everyone, Long time listener first time caller. My office has just changed to office 2007 from 2003 and it has caused one of my spreadsheets to stop working. It is a large spreadsheet filled with conditional formatting (of all kinds e.g. values and types of formulae). The conditional...

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