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

By Ja Rhule,
in Huddle Lounge

Recommended Posts

Ja Rhule Grand Master

Ja Rhule

Posted
Posted

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
Ja Rhule Grand Master

Ja Rhule

Posted
  • Author
Posted

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
sharkkiller Rookie

sharkkiller

Posted
Posted

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.

Go to topic listing

  • PMH4OWPW7JD2TDGWZKTOYL2T3E.jpg

  • Topics

  • Posts

    • Panthers Fan 69
      Canes vs Panthers 7pm

      By Panthers Fan 69 · Posted

      If it’s all the same to you guys, I’d like to use this thread for Tuesday nights game as well to keep this hate going. I have a feeling Tuesday vs the panthers is going to be violent in that arena.    @LinvilleGorgecan you please add “and Tuesday” to the game thread?  They play the Panthers again Tuesday. Thank you sir! 
    • frankw
      Why does Bryce get the blame?

      By frankw · Posted

      Nobody on the huddle is saying we have an elite group offensively across the board. They aren't great. They're young. If you are expecting someone to agree with your position of blaming everyone around Bryce Young nearly three full seasons into his career you are going to be left holding the bag save for a handful of people who act like they are paid to defend his honor. Bryce Young is not a guy who has had to claw and fight his way into starting jobs in football. He's had the best to work with and been gifted roles since he was a teenager. The Panthers have one of the youngest rosters in the league and with us needing an infusion of young defensive talent in the upcoming draft we're only going to get younger. We need a QB who possesses the ability to elevate those around him. If you can't agree with me on that then there's nothing further to discuss.
    • frankw
      Why does Bryce get the blame?

      By frankw · Posted

      All Bryce and the Panthers had to do was split with the Saints and a rookie QB. The bar was so low. They even had a whole bye week to prepare. The time for singing kumbaya was before that game. Anyone still talking about Bryce earning a second contract 43 games into his career is living a fantasy. He might get one from the Tepper owned Panthers but he's damn sure not earned it.
×
×
  • Create New...