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

    • HaricotVert
      Charlotte drivers…

      By HaricotVert · Posted

      this     I never cease to be amazed at the number of people who will run up their blood pressure to get to the grocery store 30 seconds faster or are racing to get to work like it won’t be there at 8:02.   The only thing I’ve ever done that I think added more years to my life besides quitting smoking, was to learn to go with the flow behind the wheel.  
    • Kuhndog94
      ESPN's All Quarter Century Team 2000-2025

      By Kuhndog94 · Posted

      The term you're looking for is "malinger(ed)", and he didn't.  I'm not sure why Panthers fans act like jaded ex girlfriends.  The dude is clearly injury prone as his time in San Fransico also proves. It's not like he got to San Fran and stopped having problems.
    • Gapanthersfan
      Chubba

      By Gapanthersfan · Posted

      My long and rambling post:   The guy is all heart, and I wouldn’t be surprised if he came back even better next year. He’s exactly the guy you lock up. The money won’t ever change the way he plays.  It was a big fumble, but what 1,000 yard back fumbles once in an entire season?  Pride. This team is FINALLY seeing guys who obviously take the game very seriously. Hunt, Chuba, Thielen, Brown, Horn (CB), Coker, Bryce (IMHO). Bye bye, Spider-Man. I don’t see these dudes being OK with teammates half-assing practice or in games. I can see Brown and Horn coming over to talk to somebody.  Good team? Ummm, maybe, but will still likely lose more close games than they win unless this last draft turns in to LOB part 2. That’s a stretch.  Pretty good/decent team. Yes. They finished the season as a pretty good team. I know I sound like a broken record harping back to it, but going in to ATL and putting a 40 burger on them en route to an OT win. A bad Panthers team would have had their brakes beaten off. We’ve seen it.  Rose colored glasses on and bonging a 40 of hopium: There are watershed moments that occur that change the course of franchises, both good and bad. If Fox doesn’t pull Rodney at halftime, the epic journey that was 2003 never happens. On the negative side, Cam taking that one hit from Watt was the end of any and all Panthers relevancy and we’ve been the biggest losers in all of pro sports as a result. Watershed moments. LOB draft. Vinny goes down and the goat is born.  Will the ATL game be the spark that this franchise has desperately needed? Could it be that they hit the mega million jackpot with Princley and Scourton as eat QBs for breakfast? Sure would be nice having 2 all-pro edge guys on the cheap for the next 4 years.  A lot of unknowns, but at least it actually feels  fun again. 
×
×
  • Create New...