2003 formulas crash 2007

G

Glenn

Any help or suggestions would be appreciated. I am wondering if anyone
notices why this would be working in 2003 and not in 2007.

I have a scheduling spreadsheet that works beautifully in Excel 2003 and
will not calculate in 2007. I can only work in the file with all
autocalculates off. If I F9 Excel will crash. A converted file (xlsx - made
it 1/3 the original size) will still operate in 2003 with the
FileFormatConverters installed.

Error signature
AppVer: 12.0.6214.100
fDebug: 0
Offset: 006f370a

Sheet1 is a long term schedule that has columns as weeks. Sheet2 is a
weekly schedule, a matrix of projects as rows and employees as columns. Each
intersection looks up the project number on that row, finds where the project
is on Sheet1, then checks if the employee in that column has hours scheduled
for the project and populates the cell with those hours.

The issues look like they are coming from the ProjectRangeTRH and the
ProjectRowE - These are used to represent where the project is on Sheet1.

Emp_Proj_Hrs
=SUMIF(INDIRECT(ProjectS_emp):INDIRECT(ProjectE_emp),Sheet2!BG$4,ProjectRangeHrs)
Project_Name =ADDRESS(ProjectRowS,6,1,TRUE,"Sheet1")
ProjectE =ADDRESS(ProjectRowE,WeekEndCol,1,TRUE,"Sheet1")
ProjectE_emp =ADDRESS(ProjectRowE,6,1,TRUE,"Sheet1")
ProjectE_role =ADDRESS(ProjectRowE,5,1,TRUE,"Sheet1")
ProjectRange =INDIRECT(ProjectS):INDIRECT(ProjectE)
ProjectRangeEmp =INDIRECT(ProjectS):INDIRECT(ProjectE)
ProjectRangeHrs =INDIRECT(ProjectS):INDIRECT(ProjectE)
ProjectRangeTRH =INDIRECT(TRHColStart):INDIRECT(TRHColEnd)
ProjectRowE =ProjectRowS+(MATCH("TRH",ProjectRangeTRH,0)-1)
ProjectRowS =MATCH(Sheet2!$C46,Sheet1!$E$1:$E$4072,0)
ProjectS =ADDRESS(ProjectRowS,WeekEndCol,1,TRUE,"Sheet1")
ProjectS_emp =ADDRESS(ProjectRowS,6,1,TRUE,"Sheet1")
ProjectS_role =ADDRESS(ProjectRowS,5,1,TRUE,"Sheet1")
TRHColEnd =ADDRESS(ProjectRowS+50,7,1,TRUE,"Sheet1")
TRHColStart =ADDRESS(ProjectRowS,7,1,TRUE,"Sheet1")
WeekEndCol =MATCH(Sheet2!$BD$1,Sheet1!$A$2:$DH$2,0)
WeekEndingDates =Sheet1!$M$2:$BG$2

Sheet2 sheet is the matrix of Employees along top and Projects on left. The
intersection of employee and projects have this formula:
=IF($C9=â€â€,â€â€,Emp_Proj_Hrs)
 
A

Alan124

Any help or suggestions would be appreciated. I am wondering if anyone
notices why this would be working in 2003 and not in 2007.

I have a scheduling spreadsheet that works beautifully inExcel2003 and
will not calculate in 2007. I can only work in the file with all
autocalculates off. If I F9Excelwillcrash. A converted file (xlsx - made
it 1/3 the original size) will still operate in 2003 with the
FileFormatConverters installed.

Error signature
AppVer: 12.0.6214.100
fDebug: 0
Offset: 006f370a

Sheet1 is a long term schedule that has columns as weeks. Sheet2 is a
weekly schedule, a matrix of projects as rows and employees as columns. Each
intersection looks up the project number on that row, finds where the project
is on Sheet1, then checks if the employee in that column has hours scheduled
for the project and populates the cell with those hours.

The issues look like they are coming from the ProjectRangeTRH and the
ProjectRowE - These are used to represent where the project is on Sheet1.

Emp_Proj_Hrs
=SUMIF(INDIRECT(ProjectS_emp):INDIRECT(ProjectE_emp),Sheet2!BG$4,ProjectRan-geHrs)
Project_Name =ADDRESS(ProjectRowS,6,1,TRUE,"Sheet1")
ProjectE =ADDRESS(ProjectRowE,WeekEndCol,1,TRUE,"Sheet1")
ProjectE_emp =ADDRESS(ProjectRowE,6,1,TRUE,"Sheet1")
ProjectE_role =ADDRESS(ProjectRowE,5,1,TRUE,"Sheet1")
ProjectRange =INDIRECT(ProjectS):INDIRECT(ProjectE)
ProjectRangeEmp =INDIRECT(ProjectS):INDIRECT(ProjectE)
ProjectRangeHrs =INDIRECT(ProjectS):INDIRECT(ProjectE)
ProjectRangeTRH =INDIRECT(TRHColStart):INDIRECT(TRHColEnd)
ProjectRowE =ProjectRowS+(MATCH("TRH",ProjectRangeTRH,0)-1)
ProjectRowS =MATCH(Sheet2!$C46,Sheet1!$E$1:$E$4072,0)
ProjectS =ADDRESS(ProjectRowS,WeekEndCol,1,TRUE,"Sheet1")
ProjectS_emp =ADDRESS(ProjectRowS,6,1,TRUE,"Sheet1")
ProjectS_role =ADDRESS(ProjectRowS,5,1,TRUE,"Sheet1")
TRHColEnd =ADDRESS(ProjectRowS+50,7,1,TRUE,"Sheet1")
TRHColStart =ADDRESS(ProjectRowS,7,1,TRUE,"Sheet1")
WeekEndCol =MATCH(Sheet2!$BD$1,Sheet1!$A$2:$DH$2,0)
WeekEndingDates =Sheet1!$M$2:$BG$2

Sheet2 sheet is the matrix of Employees along top and Projects on left. The
intersection of employee and projects have this formula:
=IF($C9="","",Emp_Proj_Hrs)
Click to expand...

Hi,

It seems that your file is corrupt in Excel 2007. Maybe you can try a
popular Excel file recovery tool called Advanced Excel Repair to
repair your Excel file. It is a powerful tool to repair corrupt or
damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will be useful.

Alan
 
Top