hang

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

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

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

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

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

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

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

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

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

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

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