troubleshoot

  1. D

    Trouble Pasting Into a Table

    I have an excel spreadsheet that has worked fine...until today. The spreadsheet contains a lot of data. Cells J1:BN3313 contain a large table (with a name, etc). I am having issues copying data (no matter how big or small) inside this table. If, for example, I copy a word from cell A1 and...
  2. R

    How to counteract Excel unexpectedly crashing on an overnight process

    Hi all, I'm trying to build a new tool that takes a 26 hour manual process and automates it, which should run overnight for 10-16 hours. The trouble is working around Excel crashing or halting unexpectedly. I'm testing what I have now and in the last 20 minutes it's crashed or halted three...
  3. J

    Excel Crashing IF .xlsm file not saved

    Our office is experiencing an issue where Excel will crash if a user does not save a Macro-enabled workbook that they opened. No error message is given. Is anyone else experiencing this issue? Is there anything I can do to troubleshoot what the issue is? Thank you in advance for any help.
  4. D

    File (7MB) takes 25s to save each time (?)

    I don't remember just when this happened (otherwise i could probably troubleshoot), but my file now takes 20-25s to fully complete the Save process every time I Ctrl-S save. It's a large-ish file (7-MB) with a lot of formulas spread out over a dozen sheets, but I don't remember it ever being...
  5. S

    Urgent help Needed -Troubleshooting - Email Tabs as Separate PDFs

    All, I'm new to using VBA and am trying to update my predecessors workbook and am running into an error. The macro is trying to email each tab as a separate pdf but provides the error 'Sub or Function not defined' and highlights 'Sub Mail_Every_Worksheet_With_Address_In_A1_PDF()' along with...
  6. J

    Trouble shoot vba code fine last cell

    Greetings all; I have a find last column to begin pasting data in Col A:X (returned row) The code is used earlier in the same procedure with no issue When I use the code a second time it errors out at Cell.Select Data is already in All Orgs Prod.xlsx A2:A;500 Here is the code for the first...
  7. Johnny Thunder

    VBA Help - See anything wrong with my Copy/Paste Statement? Getting an Error 450

    Hi group, I am working on a piece of code that seemed to work in the past and now I am getting a weird error? "Error 450: Wrong number of arguments or invalid property assignment". I have marked the line with the error below. I have tried several variations of the line to see if I could...
  8. T

    DAX RankX Troubleshooting with PowerPivot

    Hello, I am having issues using the RANKX function in my PowerPivot data model. I am trying to rank two different metrics by region, territory: sales and growth from last year. The sales rank works perfectly, but the growth rank seems to skip a rank when growth turns from positive to negative...
  9. D

    Power Query Moves Columns On Import

    I am running MSO Home and Business 2013. I have downloaded Power Query from Microsoft and am new to it. I understand that when I load a Query from a file into an existing file that I can say which cell to load it into. It does that but then things go screwy. Example: I have a file with data in...
  10. E

    Excel macro help

    Hello, this is my first time posting on here. I'm trying to write a macro that will string data into a word document (not just copying and pasting a table, but actually putting it in lines). I'm new at Excel so I'm trying to work off of someone else's macro..which is only kind of helping. So...
  11. J

    SUM & CountIF functions

    Hey everyone! I am hoping someone can be of assistance with my dilemma. I am currently using the formula below: =SUM(COUNTIF($B$1:$H$13,"Keith T")*0.5)+SUM(COUNTIF($B$1:$H$13,"Keith A")) The problem with the formula above is that it is subtracting the count if I place more than one String in...
  12. T

    Can't get excel to recognize numbers and not text in a cell

    It is probably a simple answer that i just have not been able to see. I have converted everything in my spread sheet to inches, then did the formula to find square ft. - No Problems there What i need to do is " lets say A1 = 66 and A2 = 66 The Sq. Ft. it gives me is A3 = 30.25. I need to...
  13. J

    Paste is not working in one file only

    I am using Excel 2010 with Windows 7. I have a file with multiple sheets, I can copy a cell or range of cells and paste it in the same sheet. But, if I go to a different sheet I cannot paste. Keyboard shortcuts, or menu options do not work. I am able to copy from this file and paste to another...
  14. B

    Active Cell Indicator Disappeared

    Hi There, I am running a macro that is causing my active cell indicator to disappear. In term of clicking around, I can still select cells, highlight cells and type formula's into cells. However, the black border that surrounds an active cell doesn't work. My file is completely macro driven and...
  15. K

    Cut Cells Marked "Closed" and Paste to New Sheet

    1 Workbook 2 Spreadsheets - "Complete Backlog" & "Closed Jobs" If Column K in "Complete Backlog" says "Closed" then cut that row and paste it into the next available row of "Closed Jobs". I have this code below but there is an error with it. It currently cuts all of the items marked closed but...
  16. bronzeboar

    troubleshooting question - multiple cells

    Hi, I am using Excel 2003. I have a coworker (we are all networked) who is using Excel and when she tries to select a cell with her mouse, its selecting four at a time. She only wants one cell. When I had her try to move around using the arrow keys, not a problem. But try to choose a cell...
  17. A

    Sort not working

    I'm trying to sort by column, which I've done a million times before, but nothing happens with this spreadsheet. Its Excel 2003 and I created the spreadsheet from a PDF document using a PDF converter program. I've done other functions to this spreadsheet to cleam it up, like converting text to...
  18. B

    Sumif with 2 Criteria

    Objective: Trying to sum data values in a column that meet 2 conditions. Specifically, the values in column A that equal value D and values in column B that equal value E. Here's my approach. =SUM(('WMB Data - JULY'!$E$1:$E$642=A11)*('WMB Data - JULY'!$F$1:$F$642=A10)*'WMB Data -...
  19. S

    Formatting Error?

    I work for a medium sized business and we use a lot of spreadsheets to organize members and such. I need help with a problem we have been having with excel lately if anyone can offer advice. We use a few large spreadsheets that are all saved in a storage device that everyone in the office can...

Some videos you may like

This Week's Hot Topics

Top