Excel hangs on calculation

  • Thread starter Thread starter snobordr
  • Start date Start date
S

snobordr

Ok, I got a three sheet excel file that I cannot get to run calculatio
on.

Sheet 1 has ~4000 rows, 10 columns. Each row has a VLOOKUP and tw
INDEX statements.

Sheet 2 has ~8000 rows, 4 columns, the data is imported via SQL query.

Sheet 3 has ~4000 rows, 4 columns, this data is imported from a tex
file.

The VLOOKUP command on Sheet 1 references Sheet 2. Each row on Sheet
has two INDEX statements, one statement each references Sheets 2 and 3.

When I get all the data in and try to calculate, I get to 30% the
Excel hangs, hard and forces a kill process and restart situation. Al
the INDEX statments appear correct, all the VLOOKUP statements ar
correct, but neither returns data that is in the referenced cells, som
come up good, some come up N/A but then, calculation never completes.

Help, I need this to work.

I did try regenerating the files by copying the template portions o
the sheet over and re-making the necessary macros and queries...
 
If you want/can, you can try to upload the file to www.savefile.com, to see
what is the problem inside...

Ok, I got a three sheet excel file that I cannot get to run
calculation on.

Sheet 1 has ~4000 rows, 10 columns. Each row has a VLOOKUP and two
INDEX statements.

Sheet 2 has ~8000 rows, 4 columns, the data is imported via SQL query.

Sheet 3 has ~4000 rows, 4 columns, this data is imported from a text
file.

The VLOOKUP command on Sheet 1 references Sheet 2. Each row on Sheet
1 has two INDEX statements, one statement each references Sheets 2
and 3.

When I get all the data in and try to calculate, I get to 30% then
Excel hangs, hard and forces a kill process and restart situation.
All the INDEX statments appear correct, all the VLOOKUP statements are
correct, but neither returns data that is in the referenced cells,
some come up good, some come up N/A but then, calculation never
completes.

Help, I need this to work.

I did try regenerating the files by copying the template portions of
the sheet over and re-making the necessary macros and queries....
Click to expand...

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
On Sheet 1, find and replace all "=" by "=". This will rebuild the dependency tree, which might help.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Ok, I got a three sheet excel file that I cannot get to run calculation
| on.
|
| Sheet 1 has ~4000 rows, 10 columns. Each row has a VLOOKUP and two
| INDEX statements.
|
| Sheet 2 has ~8000 rows, 4 columns, the data is imported via SQL query.
|
| Sheet 3 has ~4000 rows, 4 columns, this data is imported from a text
| file.
|
| The VLOOKUP command on Sheet 1 references Sheet 2. Each row on Sheet 1
| has two INDEX statements, one statement each references Sheets 2 and 3.
|
| When I get all the data in and try to calculate, I get to 30% then
| Excel hangs, hard and forces a kill process and restart situation. All
| the INDEX statments appear correct, all the VLOOKUP statements are
| correct, but neither returns data that is in the referenced cells, some
| come up good, some come up N/A but then, calculation never completes.
|
| Help, I need this to work.
|
| I did try regenerating the files by copying the template portions of
| the sheet over and re-making the necessary macros and queries....
|
|
| --
| snobordr
| ------------------------------------------------------------------------
| snobordr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36075
| View this thread: http://www.excelforum.com/showthread.php?threadid=559459
|
 
Back
Top