ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. excel
    Log in to post
    • All categories
    • Dashrender

      MS Office documents bring print settings to different computer
      IT Discussion • word ms office excel dashrender • • Dashrender

      9
      0
      Votes
      9
      Posts
      202
      Views

      siringo

      This problem sounds familiar.
      It's not a normal.dot type problem is it? Where the originator used normal.dot as their doc tempate, saved it as .dot again and it's screwing up everyone's normal.dot that reads / alters the document.

    • gjacobse

      MS Excel Formula; Hide #REF!
      IT Discussion • excel formula ref hide formula iferror • • gjacobse

      18
      0
      Votes
      18
      Posts
      178
      Views

      scottalanmiller

      We use Trello and like it a lot, but we use it for a coding process, not job tracking.

    • Dashrender

      Excel freezing
      IT Discussion • ms office excel • • Dashrender

      34
      1
      Votes
      34
      Posts
      699
      Views

      wrx7m

      @Dashrender said in Excel freezing:

      @wrx7m said in Excel freezing:

      @VoIP_n00b said in Excel freezing:

      Excel is a bitch

      Especially, here. They are running all their forecasts through it. Excel using something like 16GB of RAM for one sheet.

      As much as that likely belongs on a DB server somewhere - who's going to set it up? and program the new interface, etc?

      yeah. that has been in the works for over a year. We are syncing the data to SQL and then will be able to run queries and also export it to Domo.

    • Oksana

      StarWind Success Story: Goshen Community Schools gets a stellar-wind-speed SAN
      Starwind • excel vsan highly available fault tolerance starwind vmware • • Oksana

      1
      1
      Votes
      1
      Posts
      150
      Views

      No one has replied

    • C

      Excel 2016 on Office 365 crashes with protected view
      IT Discussion • excel ms office 2016 ms office office 365 o365 spreadsheet windows 7 windows • • cycleheat

      7
      1
      Votes
      7
      Posts
      1188
      Views

      BRRABill

      Ah, the old reboot/reinstall/redo.

    • scottalanmiller

      Copy / Paste from Excel on Mac to Outlook Web Access Creates Image Rather than Table
      IT Discussion • mac macos apple excel owa email office 365 o365 mac osx • • scottalanmiller

      11
      1
      Votes
      11
      Posts
      1034
      Views

      scottalanmiller

      @LilAng said in Copy / Paste from Excel on Mac to Outlook Web Access Creates Image Rather than Table:

      In Excel, use File > Save as web page, then attach the web page to your email message?

      Yeah, we found that process. That's a pretty huge "fail" process.

    • IRJ

      Excel - Finding duplicates in workbook and moving them into their own work sheets
      IT Discussion • excel • • IRJ

      18
      0
      Votes
      18
      Posts
      492
      Views

      C

      @DustinB3403 if you have them filtered down and want to cut/paste to another tab, you can select "visible cells only" by going to Edit / Go To... / Special... and select "visible cells only" to cut/paste just those rows visible in your selection.

    • S

      PowerBI Problem
      IT Discussion • powerbi excel • • shybrsky

      9
      0
      Votes
      9
      Posts
      1281
      Views

      S

      @DustinB3403 its been 2 years. now im using w10 . and no issue

    • Dashrender

      Win 10 1709 Outlook Excel 2016 hang
      IT Careers • dash win10 nightmare windows 10 1709 outlook excel locking up • • Dashrender

      5
      1
      Votes
      5
      Posts
      433
      Views

      wrx7m

      I have seen weird/slow response with the video/hardware acceleration turned on. Try disabling it.

    • Dashrender

      Excel - auto recover
      IT Discussion • excel dash win10 nightmare • • Dashrender

      25
      0
      Votes
      25
      Posts
      1010
      Views

      scottalanmiller

      @dashrender said in Excel - auto recover:

      @scottalanmiller said in Excel - auto recover:

      @dashrender said in Excel - auto recover:

      @jaredbusch said in Excel - auto recover:

      @dashrender said in Excel - auto recover:

      @jaredbusch said in Excel - auto recover:

      @dashrender said in Excel - auto recover:

      @scottalanmiller said in Excel - auto recover:

      @wrx7m said in Excel - auto recover:

      That is why I tell people the policy is to reboot every night before you leave for the day. Most people do... some don't. This is the exact reason why this is the policy.

      Yup, I agree, end of day reboots are the smartest if you can get people to do it.

      Most of our people do - the few (really the one) who doesn't is also the one in charge. I can't make them.

      Sure you can. If it is company policy, you simply create a schedule task to reboot machines.

      LOL - You're on a roll today!

      Just stop covering up bad behavior.

      You, and others make it sound like I have a choice here - I only have two choices, perhaps three - 1) quit
      2) according to you all ignore her
      3) just stop talking to you all about trying to find solutions to provide to attempt to fix things.

      No, you are missing the one thing we all recommend...

      The CTJ talk. The talk where you give her the options and make her choose. You don't make up the options, you just enumerate the ones that exist.

      No one has suggested any of the things you think we are recommending and missing the one choice we almost all agree on.

      Can you spell out those options, apparently I've missed them.. .I feel like I've already gave her said options.. and she chose the one not on the table - to do nothing and still complain about it.

      At which point, my option option is to basically ignore her - stop caring, whatever you want to call it, it's basically the same thing.

      You can come up with the range of known options. Examples:

      Use Google Apps and live with their save mechanism. Use local Excel and live with it's save options, either auto or off. Use Excel online and live with its save options. Use a different application, like OnlyOffice. Use Excel with auto save but get a "save all changes" storage system like Exablox

      Tell her what is possible, that's your job. Afix prices and info to each. Then make her decide. Then any complaints you just tell her "hey, talk to the person who made this decision... you".

    • Lakshmana

      Excel Automation
      IT Discussion • excel • • Lakshmana

      1
      1
      Votes
      1
      Posts
      344
      Views

      No one has replied

    • Dashrender

      Excel cell have issue, yet shows "invalid" data
      IT Discussion • excel • • Dashrender

      4
      1
      Votes
      4
      Posts
      280
      Views

      Dashrender

      The system was set to automatic.

    • gjacobse

      WordPress: Create Form
      IT Discussion • wordpress excel csv • • gjacobse

      4
      0
      Votes
      4
      Posts
      685
      Views

      stacksofplates

      Use Drupal. It's almost purpose built for this type of stuff. Custom content types and views make anything possible.

    • BRRABill

      Excel Task Question
      IT Discussion • excel • • BRRABill

      4
      0
      Votes
      4
      Posts
      540
      Views

      JaredBusch

      OK so it's a complicated pivot table but it still a pivot

    • DustinB3403

      Excel VBA
      IT Discussion • excel vba ms office • • DustinB3403

      8
      0
      Votes
      8
      Posts
      908
      Views

      DustinB3403

      Also this is what I've done, but modified the latter half of the page to keep everything in place.

    • DustinB3403

      Excel 2013/2016 Import Modules every time you open Excel
      IT Discussion • excel ms office excel 2013 excel 2016 spreadsheet • • DustinB3403

      3
      0
      Votes
      3
      Posts
      546
      Views

      DustinB3403

      Well the report is automatically generated from a system we use here. So if possible, rather than having people have to open 2 files, I'd like the modules to just import when excel launches.

      I suppose I could bury the modules into the personal file. But I'm not sure if that't the best approach.

    • RoopanKumar

      Solved Need recovery software my excel files got corrupted in my pc :(
      IT Discussion • excel ms office • • RoopanKumar

      18
      1
      Votes
      18
      Posts
      4207
      Views

      scottalanmiller

      @gjacobse said in Need recovery software my excel files got corrupted in my pc 😞:

      @RoopanKumar
      Were you able to resolve your Excel issue?

      I'm going to assume so and close this one out.

    • gjacobse

      Restructuring Text file to CSV
      IT Discussion • text editor csv excel • • gjacobse

      26
      1
      Votes
      26
      Posts
      4107
      Views

      JaredBusch

      @Carnival-Boy said:

      the wonderful, and under-rated, Microsoft Access.

      Die in a fire heretic!

    • gjacobse

      Data Export from Database
      IT Discussion • microsoft access excel csv • • gjacobse

      17
      1
      Votes
      17
      Posts
      3922
      Views

      scottalanmiller

      @JaredBusch said:

      @scottalanmiller said:

      If you learn a language just to do this, Python would be my recommendation. Specifically well suited to learning, good for doing small scripts of this nature and good for list processing like this. It's just a good fit. But yeah, if you know some other language already, definitely go with that.

      I dislike any whitespace delineated language.

      I do hate that aspect of it, very Fortrany, but it does make readability a clearer priority for the newbies and can have benefits, especially when working in teams of non-full time programmers.

    • gjacobse

      O365: Excel and OneDrive document
      IT Discussion • office 365 excel onedrive • • gjacobse

      6
      0
      Votes
      6
      Posts
      1776
      Views

      gjacobse

      Creating a new document made a difference. I've known that I needed / WANTED to recreate many of the forms and such we have for HR and the departments. A vacation request was created in WORD and dumped to PDF, which forces a person to use a pen to complete it.

      A form would be better... Especailly now with the options of OneDrive and Sharepoint....