hang

  1. G

    Excel hanging

    I'm doing some research on stock prices. I'm using the AlphaVantage add-in (Excel Add-on | Alpha Vantage) to source the price history. Currently I have 13 sheets of stock data with about 5000 lines -- large, but nothing extraordinary. Most of that space is populated by an AlphaVantage call in...
  2. B

    progress doughnut chart

    I am new at utilizing the 95% of excel that I haven't used etc. etc…. I am very interested in getting better educated and your information is so helpful but I have a question about the doughnut progress chart. I am getting the hang of it but have revenue that exceeds goal and would like to show...
  3. proficient

    lookup dates and gather same dates items

    Hi All, I am working on a sheet, there is a unique ID for all items mentioned in headers that are more than 30 (but I have mentioned some of them as example) and their status below them i.e dates (ETA) or IN-HOUSED (means item received). What I want you guys to do is that if items for a...
  4. S

    Save As (VBA) stopped working

    I have code in a macro to prompt the user to save the file, followed by a message box to say the task is complete. MsgBox ("Please save the report") file_name = Application.GetSaveAsFilename(FileFilter:="Microsoft Excel file (*.xlsx), *.xlsx") If file_name <> False Then...
  5. X

    Inserting copied row code causes Excel to hang (swirly blue circle)

    Hello one and all, I've inherited a Macro enabled spreadsheet I'm trying to make work on Excel 2013, it works OK on Excel 2007 and below. Problem: Manually selecting, copying and inserting a row works OK; however, when running the code below on later versions of Office it causes Excel to stop...
  6. A

    what sort of computer to get

    folks, I do a lot of data crunching and make some big spreadsheets for a large company. with the amount of policy stuff running in the background plus my (most probably) personal code/formula style, I seem to always get issues with time. I either get to take a lunch break while files save or I...
  7. X

    Opening a File and Macro Issues

    Hello I have a file on a corporate network, that uses macros and has an Workbook_Open event. For months there has been no problem with Enabling Macros on opening (as I only have security set to medium) and Don't Update Links (as there are few links to external files). There has been no change...
  8. T

    DataObject.PutInClipboard causes Excel 2010 to hang

    Hi, My first post! Hopefully all inline with Forum rules ... :) I'm a relatively experienced Excel / VBA user, but I've come across an interesting problem. I develop/own a large set of workbooks that contain code, and recently users have been complaining that Excel has been hanging, with no...
  9. T

    When I add the following code, a previously well running macro freezes

    Set crange = Worksheets(3).Range(Worksheets(3).Cells(5, 2), Worksheets(3).Cells(2, 5).End(xlDown)) Set prange = Worksheets(4).Cells(1, 26) crange.Copy prange.PasteSpecial Paste:=xlPasteValues Set crange = Worksheets(3).Range(Worksheets(3).Cells(203, 2)...
  10. B

    Excel 2010 hangs/crashes on a daily basis!

    Hi folks, I am running: Microsoft Excel 2010 Microsoft Windows 7 Professional 32-Bit --- I have just migrated to a new machine, with a fresh copy of windows and office, and the identical problem from the previous machine remains, so please help! --- At random points several different...
  11. M

    Spreadsheet crashing Excel

    Hi all, We have an issue with a shared sheet causing one user's excel to hang and needing to be killed in task manager. the facts: Sheet created in Office 2003 Sheet is 6.5MB Sheet has external links to other workbooks It works for all other users (even on the same PC that the affected user logs...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top