Excel 2010 :: Stopped Working When Building Charts?

Jan 15, 2013

I'm working on a macro that does the following:

1. Pull data from the internet
2. Perform calculations on the data
3. Graph the calculated values

- As I run the macro, Excel dies in step 3, where I graph the calculated values.
- It works about 5% of the time and gives me the "Excel has stopped working" error 95% of the time - I can't isolate any difference in the attempts
- I've located the area in the macro where it dies, but I can't identify the exact line since it seems to shift around in this area
- It works perfectly fine when I step through using F8
- I've attempted DoEvents and Application.Wait to debug. Application.Wait for 5 seconds allows the macro to work about 50% of the time and increases in efficiency the longer I wait
- Steps 1 and 2 work perfectly fine (I've used that code in many macros), so I'm pretty sure the issue is in the below code:

I'm running Windows 7, Office 2010

Code:
'Chart variables
Sheets("Summary").Select
Dim ChartRange As Range

[Code]....

View 4 Replies


ADVERTISEMENT

Keyboard Stopped Working In Excel

Apr 18, 2012

I have been working on a workbook, and all of a sudden, my keyboard no longer worked in Excel. No shortcuts, no CTRL+C, no CTRL+V, no CTRL+S, no CTRL+A, no F12 to save, no letters, no numbers.... The only button that is working is my ALT key, and I use the other letter keys just fine to navigate after pressing ALT.... But that's it!

I have still been able to work on it because I can still write in Word, and I can still write more code in the Visual Basic window, and I can still click the buttons I create under the Developer... but it's still frustrating to not be able to type a thing in any of the cells, formula bar, or be able to use any of the shortcuts. And now when I tried to close it, I can still select everything else, and I can close this workbook, but it won't close Excel.

View 3 Replies View Related

Microsoft Excel Stopped Working Error

May 15, 2014

I have a Macro button in my Excel Spreadsheet, every time I close the spreadsheet it gives me this error "Microsoft Excel Stopped Working" .

I have attached Spreadsheet to show example : Inventory List.xlsm‎

View 2 Replies View Related

Excel 2003 :: Auto Filter Stopped Working?

Sep 12, 2013

I've got a spread sheet at work that is shared between 4 people. It's password protected and its been protected so only four of us can edit it. It was working fine until yesterday for no reason the auto filter stopped working. The drop down arrows are still there but nothing happens when you click on them?

The sheet was made on excel 2003 but one of the users uses the newer excel which we will all eventually get.

View 2 Replies View Related

Errors - Microsoft Excel Has Stopped Working - Crash In Pivot Table

Jun 10, 2013

I have created several reports containing pivot charts with slicers, pivot tables and data sets. Total file size is around 5MB. Need to do an update in my pivot table Like adding an additional grouping on one of my dimensions. As soon as I start doing so the Microsoft Excel stopped working error message pops up and my file crashes! Removing existing groupings seems for some reason to be impossible as well: nothing happens when I do this. Ahow to solve this without having to rebuild all my reports?

View 1 Replies View Related

Excel 2010 :: Building Text File Based On Values Of Cell?

Feb 26, 2014

I'm trying to use Excel to build a text file based on values from certain cells in Excel 2010. This is based partially off of static text that never changes and variables that will need to change. For example, I want Excel to output a text file that has the following text: The red fox jumped over the $X twice. I would want $X to be replaced by the value of A1 of the active worksheet. I will also have several lines like that, so it won't just be a single line, but anywhere from 20 - 120.

View 1 Replies View Related

Building Legend Of Chart Titles Linked To Charts

May 14, 2014

I have a sheet with about 50-60 charts and I am hoping to have a master list of chart titles on the side, how can I link these titles with the charts themselves?

View 1 Replies View Related

Debug F8 Stopped Working

Jun 22, 2008

I recently got a new laptop. I now have excel 2007 and vista. The debug step key, F8, does not work. It toggles out of excel when pushed. If I start the procedure in the debug menu, the SHIFT - F8 will step through though. Is there a setting I am missing? It must have somehting to do with VISTA since in the debug section it says to use F8.

View 3 Replies View Related

Application.SendKeys Stopped Working

Aug 17, 2007

I have a simple macro that from Outlook Express sends emails, with the last code line to mimic ALT+S on the keyboard to send the message

Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%s"

Yesterday I needed to install some new software that required at the end reinstalling of Microsoft Redistributable 2005. Not sure if for that reason but now the last line (the SendKeys) is not sending the email automatically anymore. What happens is:
-the email message windows pops up but is not being sent unless i do it manually (if i get rid of the two seconds pause ahead of that)
-have a VB error message that takes me before the SendKeys line (if I keep the two secs wait ahead of that)

It looks to me that either:
-the pc is not active anymore on the email message therefore the SendKeys doesnt work
-somehow the instruction finds the "door" shut by something else
-worse of all, the software has messed up with those send keys commands (tried to reinstall it but to no avail)

View 13 Replies View Related

2007 Macros Have Stopped Working

Dec 14, 2007

All my macros have suddenly started crashing Excel 2007 when I try to run any one of them. I can record a new macro but even that newly recorded macro will crash Excel.

Service Pack 1 was downloaded and installed by Windows Update two days ago and I had successfully run macros after SP1 was installed.

Today, it's a no go and I'm at a loss as to what may have caused this problem. I have not installed any software lately, other than the Windows updates on patch Tuesday.

This is on a Vista Home Premium machine.

When I try to run a macro, Excel crashes with this info:

View 11 Replies View Related

Macros Have Suddenly Stopped Working

Jan 16, 2012

why my Macros have suddenly stopped working for no apparent reason?

For Example - one macro would run when a Cell in Column A was selcted. It would trigger a macro to save the workbook.

I'm not giving details of what the specific macros do as it's more of a question as to why macros in a workbook just suddenly cease to function.

View 4 Replies View Related

Days360 Function Has Stopped Working?

Feb 25, 2014

I use this formula in a depreciation schedule to determine months in service.

=ROUND(((DAYS360(G12,$Y$1,FALSE)/30)),0)

G12 is my start date and $Y$1 my end date. Every month I update this to the current period end date and up until now, it has recalculated.

Today, I changed $Y$1 from 1/31/2014 to 2/28/2014. The cells with that didn't update. For giggles, I entered in previous dates, and it worked fine.

Is it because 2/28/14 is a future date? I tried 2/24/14 with no joy...

View 1 Replies View Related

Autofilter Code Stopped Working

Feb 20, 2007

What could make this line of code stop working. It has worked for weeks, and just yesterday it stopped working. :x

ActiveWorkbook.Sheets("Email").UsedRange.AutoFilter Field:=2
The sheet is unprotected, and events are enabled. I don't know of anything different than before. What do I look for that would not allow this code to run?

View 9 Replies View Related

Formulas Referencing Cells Stopped Working

Aug 11, 2009

I made a spread sheet last year that used various COUNTIF formulas that referenced other cells. =COUNTIF(I40:ER40,"A") It worked perfect.

I copied that spreadsheet to use for this year. I cannot get this formula to work. I have reentered in various locations and forms, but to no avail. If I enter the data and then enter the formula, it works.

However, if I enter the formula first and then enter the data (which I will do over the course of the year) it does not work. I even tried to reconstruct all of this in a brand new spread sheet and it still is not working, although last year's spread sheet still works.

View 3 Replies View Related

Macro Has Stopped Working After Date Change

Dec 1, 2009

When the date changed today it stopped working and I cant see why as i have altered the dates that it looks at.

View 4 Replies View Related

Excel 2010 :: Pasting Charts To Other Worksheets

Sep 29, 2011

I have a simple problem. I have many worksheets which all contain data in the first four columns. I want to be able to create a chart (a scatter chart) in the first worksheet which plots the data on that worksheet and then format it how I want it to look. This I can do.

Next, I want to copy and paste that graph into all the other worksheets, but have the pasted graphs display the data in that worksheet.

As it stands, in Excel 2010, all the pasted graphs keep showing the data in the original worksheet irrespective of which worksheet I now have them in. This seems to be different to older versions of Excel and is very annoying and has to be changed by hand which is very time consuming.

How can I make charts that don't have the worksheet name in the cell reference, or how can I paste a chart so that is updates the references to the same row and column but in the new worksheet?

I know I could copy and paste the entire worksheet and then manually copy the new data into that copy of the worksheet - but that is not a real solution to this problem.

View 2 Replies View Related

VLookup Stopped Working Unless Hit Enter While Cursor Is In Formula Bar

Aug 3, 2012

This vlookup has been in this workbook for years. All of a sudden any of the cells that have formulas won't work without placing the cursor after the formula in the bar and hitting enter.

It is keeping a marco from running correctly.

View 2 Replies View Related

VBA Lost Access To IE And Stopped Working - Runtime 438 Error

Feb 17, 2013

I'm scraping a website for some data using the following program. The program was working as expected until I decided to add a save file element that was a copy paste of some code a friend gave me (attached below). Funny thing is the save file functionality works but now I can't get IE to load the webpage - I get a 438 Error. I'm thinking there's a problem with something in the references menu.

Code:
Sub GET_PVI()
Dim Days_in_Month(1 To 12) As Integer
Dim Name As String

[Code]....

View 2 Replies View Related

Excel 2010 :: Creating Charts With Average Line?

Apr 5, 2012

How I could create a chart (standard column) with an average line in Excel 2010?

View 4 Replies View Related

Excel 2010 :: Graphical Interactive Data Changes In Charts?

Sep 19, 2012

I am looking for a way to manipulate xy data graphically by moving points in an excel scatter plot. This functionality was present in older versions of excel, but I can't seem to do it in the MS office 2010 version.

View 1 Replies View Related

Excel 2010 :: Won't Correctly Display Charts / Graphs

Apr 27, 2013

I am using Excel 2010 to create a simple chart. When I enter the information, highlight it and select a chart, the chart area appears blank. It doesn't matter what kind of chart I choose- it still appears blank. I've tried going into the Advanced options and indicating for All objects to be shown and that didn't work.

View 1 Replies View Related

Code Stopped Working - Can No Longer Copy And Save Worksheet

Jul 31, 2012

I have been working on this application for the past couple weeks and I have this module of code that copy's a worksheet into a new workbook and changes everything into values. However I have added buttons onto this sheet and after running the code again it froze the program, in which I had to manually end. It gave an error afterwards however I don't remember what it said. Now everything I try to run or step through it, nothing happens. And I have turned Events and ScreenUpdating on.

I would also like to note that it won't allow me to perform actions like unhide sheets or unprotect them. The code has not been changed either so what has happened to disable all functionality.

[URL] .....

View 1 Replies View Related

VBA / Code Stopped Working - Can No Longer Copy And Save A Worksheet

Jul 30, 2012

I have been working on this application for the past couple weeks and I have this module of code that copy's a worksheet into a new workbook and changes everything into values. However I have added buttons onto this sheet and after running the code again it froze the program, in which I had to manually end. It gave an error afterwards however I don't remember what it said. Now everything I try to run or step through it, nothing happens. I have turned Events and ScreenUpdating on.

View 2 Replies View Related

Cut / Copy / Format Painter Stopped Working (Don't Have Skype Click To Call)

Aug 23, 2013

When I copy or cut, I usually get a dashed border around the cells I have copied (or cut), I can then right-click somewhere to paste, but at some point in time recently this functionality has stopped working. The format painter doesn't work either - the paintbrush icon stays pressed for about half a second, then just goes away and I can't paste my formatting.

An operation I often do in excel is to copy a date from one cell, then highlight a few cells elsewhere and press enter to paste the date into them. I also like to right click on a row and Cut, then past it further down my list to re-order things, but this won't work either.

I don't know what I've done to make it go away. If I restart my computer and open a workbook, then I can copy/paste at least once (maybe a few times) then it stops again.

This is caused by a Skype 'click to call' function, but I don't have that installed here. I have actually just tried installing it, so I could run through the uninstall (thinking there might be debris from something previously), but it made no difference.

View 2 Replies View Related

Excel 2010 :: Populate Ranges To Facilitate Dynamic Charts Being Generated

Nov 2, 2013

I'm trying to dynamically populate ranges to facilitate dynamic charts being generated.

I use excel 2010 at work, and 2011 for mac at home.

Dynamic chart ranges populated from named ranges as selected in nested indirectly sourced validation lists

I want any selection made in a dependent validation list which contains a list of named ranges to trigger a worksheet_change event which copies the range the selection points to and pastes it into a dynamic range in another column, beginning as a specified cell.I've tried using this, put together from some code examples from similar, but different issues.

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("B2")) Is Nothing Then
Range(Range("B2").Value).Copy
Range("P2").Paste
End If
End Sub

Trouble is, I don't really understand this code. It doesn't appear to do anything when I make a worksheet change in "B2", but I don't know exactly what it is. I suspect that perhaps the fact that "B2" is validated from an indirect source might be difficult?

View 8 Replies View Related

Excel 2010 :: Print Hundreds Of 6 Column Charts Using Maximum Page For Printing

Apr 28, 2013

I am using Excel 2010

I have over 800+ pages of chart that only takes up 6 columns and around like 9000+ rows.

I wanted to print this chart on paper and need hardcopies. However, the chart in its current setup prints only on the left half of the page leaving the right half empty.

How do i make use of the full space properly? Each chart has a "page number" on it so I want the chart to print continuously from one half of the page onto the next half and then the second page, third, etc.

Here is a visual demonstration of how things currently are and how i'd like to get them to be:

As you can see, This is the first of many charts and its numbered Page 9 and next one is page 10.

Pic1

How this looks when i try to print, it's only on the left side. right is all blank
Pic2

How i want it to look like upon printing
Pic3

As you can see in the last picture, once page 14 chart has no space it automatically continues chart on right side of page and then moves on to print rest.

[URL]

View 7 Replies View Related

Excel 2010 :: Template Only Has 5 Working Days In It?

Apr 8, 2013

I am using Excel 2010. The template only has 5 working days in it, but I need to set 6 working days (Saturday is also working day). Wondering, how to get this working without spoiling the functions. Also the date format is in US , need to change to UK without disrupting the Formula/Functions.

View 12 Replies View Related

Excel 2010 :: Generate GetPivotData Not Working?

Dec 10, 2012

In Excel 2010, I can manually enter the GetPivotData function (and it works), but with Generate GetPivotData selected / enabled (in PivotTable Tools --> Options --> PivotTable --> Options), the GetPivotData function isn't automatically generated.

View 1 Replies View Related

Excel 2010 :: Links Not Working For End Users

Jul 12, 2013

I am using Excel 2010 on Windows 7.

I copied (with 'Paste Link') rows from a master Excel file to a file that performs calculations. This file (and many others like it) need to be modifed by other people. My tester has informed me that the data is not updating between the files for her, although it does work for me.

When I check 'Data->Edit Links' it shows the status of the file as 'unknown'. If I click 'Check status' it is then OK, but the next time I look at it, it has reverted to 'unknown'.

1. How do I get the status to remain at OK?

2. Why do the links work for me, but not for my end users?

View 2 Replies View Related

Excel 2010 :: Macros Not Working In Windows 7

Apr 29, 2014

I have a macro to collate data from multiple workbooks to a single sheet. The folder path to the source files can be chosen thorugh the macro. It runs perfectly in my system running on Windows XP. But it doesnt run on Wondows 7 system. Both are using MS Excel 2010. In Windows 7 system, while choosing the folder path where source files are located, it says "No items match your search" (screenshot attached). I would want the macro modified so that it runs on any platform. The macros that I'm using is given below:

[Code] .....

Untitled.png‎

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved