Any IT people on here?

[Ja Rhule]

We're having some issues with our excel files.  I'm an accountant and it's year end and it's very fraustrating.

 

We employe many large excel worksheets for calculating large amounts of data. Many of these worksheets are linked to each other. We tried to refresh our links and recalculate the worksheets but they constantly freeze up and/or crash. Sometimes it takes over an hour to recalculate a file that only took 30 seconds a months ago. We think it might have to do with the fact that our IT department compressed our drive. Can compressing the drive cause major excel issues? And how should I go about fixing it?

 

 

[Darth Biscuit]

Not certain, but I think compression of the files could certainly affect them.

 

I don't recommend people do that.  It's not necessary.  Hard drives are cheap... apparently your IT people are cheaper.

 

Do you have the original uncompressed versions?

[frash.exe]

Yea did they back it up before compressing it?

[Ja Rhule]

Yea did they back it up before compressing it?

 

Of course not...

 

We got a year end and we hoping there is a way to fix it ASAP.

[Inimicus]

There is not likely an easy fix.

 

 

If you dont have backups from before the "slowdown" the only real fix (100% sure fire) will be to recreate the files in new spreadsheets.

 

 

Whats "large"?

[frash.exe]

Of course not...

We got a year end and we hoping there is a way to fix it ASAP.

Yikes

[cookinwithgas]

Copy the compressed file(s) to an uncompressed location and try again. Fire IT staff for being stupid.

[Ja Rhule]

There is not likely an easy fix.

If you dont have backups from before the "slowdown" the only real fix (100% sure fire) will be to recreate the files in new spreadsheets.

Whats "large"?

Let's say 12 tabs. 45 rows by 45 columns in each tab and linked to other similar files. Probably total of around 60 excel files but not all connected to one another. I'd say 12mb of data per worksheet max. Some are only 2mb.

[Guest]

Reset the data cube. 

 

 

 

 

 

 

 

Boom. 

 

 

[sharkkiller]

If they moved the files when compressing, then the slow down may be from it trying to locate the data. Try reentering the formulas to recreate the data paths. You may also just copy the data into a new excel file, and start again with new uncompressed files. 

 

Please note: I am not an IT person, but I do work with excel quite a bit. 

[PhillyB]

kick the computer