Jump to content

Build Theme!
  •  
  • Infected?

WE'RE SURE THAT YOU'LL LOVE US!

Hey there! :wub: Looks like you're enjoying the discussion, but you're not signed up for an account. When you create an account, we remember exactly what you've read, so you always come right back where you left off. You also get notifications, here and via email, whenever new posts are made. You can like posts to share the love. :D Join 92320 other members! Anybody can ask, anybody can answer. Consistently helpful members may be invited to become staff. Here's how it works. Virus cleanup? Start here -> Malware Removal Forum.

Try What the Tech -- It's free!


Photo

Excel freeze-up when altering Name


  • Please log in to reply
8 replies to this topic

#1 K e n

K e n

    New Member

  • Authentic Member
  • Pip
  • 11 posts

Posted 18 January 2012 - 05:27 PM

In a number of worksheets.I am using a Name, AverageOfThisRowUpToColumnPreviousToThisColumn. The Name refers to the following formula: =FIXED(SUM(INDIRECT(ADDRESS(ROW();2)):INDIRECT(ADDRESS(ROW();COLUMN()-1)))/COLUMN()-2;2), which gives the average of cell contents in a row from column B up to the column before the one containing the Name. Works OK, BUT... Why does Excel crash whenever I try to alter the formula in a cell already containing this Name, or whenever I try to introduce the Name into a new cell? About the only thing I can do without provoking an immediate collapse of Excel is to copy succesful cells containing the Name across (or down). I don't have this problem with other Names. --- Ken

    Advertisements

Register to Remove


#2 appleoddity

appleoddity

    SuperMember

  • Tech Team
  • 3,071 posts
  • Interests:Eating, Movies, Family, Church, Music, Volleyball, Softball, Poker, Computers, Electronics, Reading.

Posted 26 January 2012 - 09:53 PM

My suggestion would be to upgrade to a newer version of Office, make sure you have installed all your Microsoft updates for Office, and/or reinstall Office.

The help you have been given is free. If you have been happy with our help please consider donating to support this forum.

If you would like to say thanks for the help I have given you please View My Profile and Leave a Comment.
Your encouragement is welcome.


#3 K e n

K e n

    New Member

  • Authentic Member
  • Pip
  • 11 posts

Posted 01 February 2012 - 10:24 AM

My suggestion would be to upgrade to a newer version of Office, make sure you have installed all your Microsoft updates for Office, and/or reinstall Office.



#4 K e n

K e n

    New Member

  • Authentic Member
  • Pip
  • 11 posts

Posted 01 February 2012 - 10:50 AM

Thanks for your attention, appleoddity.

I wrote the formula within Office 2007 and would feel very much cheated if I had to acquire newer software in order for it to function properly. I have only just reinstalled Office and Windows7 after a major crash. The problem I describe occurred both before and after the reinstallation. What really puzzles me is the fact that the construct works (given an additional pair of brackets around "COLUMN() - 2", which I inadvertantly left out in my original posting). It just refuses to let me alter (improve?!) it.

K e n

#5 appleoddity

appleoddity

    SuperMember

  • Tech Team
  • 3,071 posts
  • Interests:Eating, Movies, Family, Church, Music, Volleyball, Softball, Poker, Computers, Electronics, Reading.

Posted 01 February 2012 - 11:29 AM

Hi Ken. Have you installed all your Microsoft Office service packs and updates? Office 2007 should be at service pack 3. In Windows 7, you must choose to check for updates for "windows AND other products" in order to receive Office updates. You find that setting by choosing Windows updates from your start menu under programs. Its possible this is a known issue and has been fixed with updates. Other than that, I am not an Excel expert - sorry. But, my own personal solution would be to try to delete the formula and re-create it from scratch. Or, scrap the file and start over from fresh, trying to copy and paste the information that you can. I just don't have any other suggestions for you.

The help you have been given is free. If you have been happy with our help please consider donating to support this forum.

If you would like to say thanks for the help I have given you please View My Profile and Leave a Comment.
Your encouragement is welcome.


#6 K e n

K e n

    New Member

  • Authentic Member
  • Pip
  • 11 posts

Posted 02 February 2012 - 05:59 AM

Hi, Appleoddity, I have just checked my update history; One entry was "The 2007 Microsoft Office Suite Service Pack (SP3)" . Tthe status was "Successful" and the Date Installed "29.12.2011". So if there's nothing wrong with the formula then this must be another Excel bug. I'll try your other suggestions to see if that makes a difference; but that still would not explain why the fault keeps happening- and that is what is bugging me most of all. Thanks again, K e n

#7 paws

paws

    Tech Team

  • Administrator
  • 6,046 posts

Posted 02 February 2012 - 04:12 PM

Hi, Have you tried opening your Excel file using different computers...running Win XP, Vista, 7 etc and see if the problems persists? Try different versions of Excel...2007 and 2010 and as a standby also try a machine with Excel 2003 (with the file format converter included) If all the machines running all versions of Windows and all versions of Excel all have the same identical problem...you will at least know where you stand. Regards paws
The help you receive here is free. If you wish to show your appreciation, then you may donate to help keep us online. http://www.whatthetech.com/donate

#8 K e n

K e n

    New Member

  • Authentic Member
  • Pip
  • 11 posts

Posted 08 February 2012 - 07:22 AM

Hallo, Paws. Sorry to be so slow to react (just got back after hospitalisation for brocken fingers). Thanks for your suggestions: however, I'm afraid my knowledge of the software involved is insufficient to allow me to interpret the results of the tests you mention: I would, in fact, not "know where I stand". I have an old PC with XP and an older Office version. Asoon as I can use my injured hand again I'll drag it out and experiment. K e n

#9 paws

paws

    Tech Team

  • Administrator
  • 6,046 posts

Posted 08 February 2012 - 08:19 AM

Hi Ken, sorry to hear about the fingers...I sure hope they mend soon... :thumbup: Yes when you are ableto.... try to use the alternatives I suggested.... There's no interpretation needed... it'll either work or it wont! Regards paws
The help you receive here is free. If you wish to show your appreciation, then you may donate to help keep us online. http://www.whatthetech.com/donate

Related Topics



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users