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

    • Proudiddy
      Sold / Not Sold

      By Proudiddy · Posted

      Also, in regards to XL and guys like Renfrow and JHJ, it’s hard to truly evaluate them because they aren’t getting enough opportunities.  XL, to me, seems like he turned a corner, which was evident in that career game a couple of weeks ago…  but then he’s only getting a couple of targets over the next couple of weeks.  Not to pile on Bryce because everyone knows where I stand on him, but it’s because of him.  Bryce made a nice throw to him yesterday, XL made a nice clutch grab, and then a packers defender took a cheap shot on him and he was out for a bit (I believe he came back?).  But, overall, it feels like for most of our WRs it’s feast or famine and no in between:  it’s not enough consistency in targets and distribution.
    • mrcompletely11
      Sold / Not Sold

      By mrcompletely11 · Posted

      Pretty sure it was both.  And the screen throw to rico that he literally jumped to do and it sailed over his head.  That type of poo is not fixable
    • LinvilleGorge
      Sold / Not Sold

      By LinvilleGorge · Posted

      I just think it was an awful throw. He was trying to throw to the back pylon and just missed terribly. He had a little bit of pressure in his face and he can't deal with that. That's when the awful throws usually happen. I don't have a problem with that shot if it's thrown to the back pylon where it should've been. That ball thrown correctly to the outside is either caught by XL of is safely missed high and/or outside. You cannot miss that throw short and inside.
×
×
  • Create New...