#VALUE! Error from one version to another (without any structure or content change)

Hello all,

Ok, in my company there's an Excel time record sheet which we must use to record our time utilization per month (this time utilization is assigned to different projects, depending what specifically each one of us is working on).

This file was not created by me, the colleague who created it left a couple of years ago and I have been responsible for its maintenance since then.

This is a German company. The original file was created with an Excel German version. However, the displayed texts in the Excel sheet are in English (is the company's official language), for instance, "Reason of absence", "Task Description" and so. I don't know if this information is relevant, but just in case, I provide it.

Some of my colleagues have migrated their Microsoft Office versions from 2007 to 2010. The original file was created in the 97-2003 Version, but has had no problems to be opened in the 2007 version (however, it has to be saved specifically in the 97-2003 version to keep all its characteristics).

The specific problem is that, without modifying at all the file, once I want to open it in the 2010 Version, I get a huge amount of #VALUE! error messages (literally, almost all formulas in the Workbook have references to another place WITHIN THE SAME FILE). I have tried to open these same files in the Excel 2007 Version and I haven't had any problem. My first thought is that this is a adapting-Settings issue in the 2010 Version.

Does anyone have an idea?

Im Voraus, vielen Dank!

Luis

Are there any macro in the spreadsheet?

Also, did you try converting the file in 2007 to 2007 version (xlsx/xlsm/xlsb) and reopening it in 2010?

Thans quekbc, these are my answers to your questions:

1) Yes, there are macros in the spreadsheet. I just select the "activate macros" option when I'm prompted to do so (by opening the file).
2) Yes. I tried. But the result is still the same.

I'm attaching an example of this aforementioned file...by itself, is a compendium of Excel formulas

WORKTIME_BEISPIEL_2015_KW01.xls