Jump to content
  • Welcome!

    Register and log in easily with Twitter or Google accounts!

    Or simply create a new Huddle account. 

    Members receive fewer ads , access our dark theme, and the ability to join the discussion!

     

Any IT people on here?


Ja  Rhule

Recommended Posts

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?

 

 

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.


  • PMH4OWPW7JD2TDGWZKTOYL2T3E.jpg

  • Topics

  • Posts

    • My take on Darnold was always that he was fine with a good offensive line but would wilt under pressure with a poor line (Jets and Panthers). Seattle began the year w/ a pretty bad oline and they improved somewhat but Darnold is showing he is a pretty good qb. Imagine what the Panthers would be today with Darnold and without Bryce Young and all the wasted draft picks to get him.  
    • Similar situation but that would be a better version than what we currently have. Sam isn't a franchise QB but he is a good bridge guy. Either Seatle finds a young guy to groom or they have hit their ceiling. They 100% can't put it on Sam's shoulders and expect to win but the team needs to carry less with him at QB to win vs what this team has to do with Bryce.
    • to me the post would suggest Sam Darnold was good last night because Seattle won in a wild game.   Which is what we do with Bryce Young.   Sam Darnold didn't play well last night.  Which is how he trends, goes to a new team.....looks okay and becomes classic Sam Darnold down the stretch.  Last 6 or 7 weeks old bad Sam is coming out a lot (and then a weird Atlanta game mixed in lol). 
×
×
  • Create New...