troubleshoot

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 -...

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...