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

    • Jmac
      Should Dave Canalas be on the HOT seat??

      By Jmac · Posted

      Nope
    • cranky
      Who is going to take a shot at Malik Willis

      By cranky · Posted

      So Willis had a good game against a poor defense and all of a sudden he is worth 50 million and is guaranteed to be better than Young. LOL I know he looked good in the 3 games he started, and I think he will have success long term, but anyone signing him up for a long term contract for 50 million is taking a huge risk. 
    • cranky
      Should Dave Canalas be on the HOT seat??

      By cranky · Posted

      Is he really though? Rivera was past his prime and probably shouldn't have even started 2019 so his firing wasn't really unexpected or unwarranted. Rhule lasted two and a half years which was about one year too long in my opinion. Bringing him back that third year certainly wasn't impulsive and I would say Tepper was more patient than he should have been. Wilks finished out that third season and did pretty good but most everyone could see he really wasn't anything more than an intern HC. Bringing him back was not the long term answer so not bringing him back was the correct call. Hiring Reich was a mistake from the beginning and he recognized that fairly quickly. I am sure he knew he was going to catch a lot of sh*t for firing him so quickly ( and boy did he ) but it was absolutely the right thing to do given everything that was going on. The firing may have looked impulsive, but I think it was him recognizing he had royally f*ck up and just dealt with it instead of letting it fester.  That brings us to Canales. 2025 was only his second season and yet he delivered 8 wins and the NFC South title. And while that might not sound great, given the lack of talent and cap space they started with, it's a strong step in the right direction. I couldn't imagine Tepper not being pleased with their progress given the crap the Panthers' have been though under his ownership.
×
×
  • Create New...