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

    • frankw
      Why does Bryce get the blame?

      By frankw · Posted

      The same folks crying about the OL right now were crying about it in 2023 too. We have tied up over 100 million dollars in two interior olinemen alone. We've invested multiple first and second round picks in the offense. We hired an offensive minded head coach. This is an offensive team. The offense needs to produce or people need to be replaced.
    • frankw
      Why does Bryce get the blame?

      By frankw · Posted

      This is the same place that has ridiculed and blasted Caleb Williams at every opportunity he has his team sitting at 10-4 in the same NFC that the Panthers are competing in. And their division in the NFC North is as or more competitive as our division. Yet from the same people who have very high standards for Williams we get every excuse imaginable for the smallest starting QB in the league even when he and his team continue to disappoint when the pressure is on. You lot aren't any less inconsistent than anyone else.
    • *FreeFua*
      Why does Bryce get the blame?

      By *FreeFua* · Posted

      The Panthers are 9th in cap spent on offense this year.  However next season is already a different story  The Panthers as it stands right now will be 18th in cap spent on offense and 8th in cap spent on defense  The Panthers are currently set to spend more on defense next year than they are on offense this season Guys like Jaycee and Moehrig cap numbers take a big jump. Wharton has a massive cap hit   Jaycee Moehrig and Wharton in 2025 The same 3 in 2026 So this same defense as it stands right now will cost more in 2026 than this offense does right now… Got anything else you want to try?
×
×
  • Create New...