Guys,
We've been upgrading a number of uses from Office 2007 to 2010, on the whole this has gone okay, however, one user is having problems with one specific spreadsheet. When she attempts to open this spreadsheet on her PC (With Office 2010) she receives the error message:
"Excel cannot complete this task with available resources. Choose less data or close other applications"
The file opened fine in 2007 Excel.
I attempted to open the file (firstly from the network share it resides on and then locally from a copy on my desktop), I received the same error, the machine I was trying to open it on is pretty beefy- 8GB RAM, 8 processors etc.
I tried to open the file in Excel 2007 on one of our laptops (of very moderate/low spec) and it opened just fine in 2 ticks.
The file in question is rather odd in that it has a very large number of tabs (think ~ 300, I stopped counting at 140), each one doesn't have a huge amount of data though - the file is only about 4 mb.
Any thoughts on this would be much appreciated - I'm guessing it's just a change to the rendering engine which MS have made which in this instance cause problems, however, any other thoughts are most welcome Thanks!
We've been upgrading a number of uses from Office 2007 to 2010, on the whole this has gone okay, however, one user is having problems with one specific spreadsheet. When she attempts to open this spreadsheet on her PC (With Office 2010) she receives the error message:
"Excel cannot complete this task with available resources. Choose less data or close other applications"
The file opened fine in 2007 Excel.
I attempted to open the file (firstly from the network share it resides on and then locally from a copy on my desktop), I received the same error, the machine I was trying to open it on is pretty beefy- 8GB RAM, 8 processors etc.
I tried to open the file in Excel 2007 on one of our laptops (of very moderate/low spec) and it opened just fine in 2 ticks.
The file in question is rather odd in that it has a very large number of tabs (think ~ 300, I stopped counting at 140), each one doesn't have a huge amount of data though - the file is only about 4 mb.
Any thoughts on this would be much appreciated - I'm guessing it's just a change to the rendering engine which MS have made which in this instance cause problems, however, any other thoughts are most welcome Thanks!