+ Post New Thread
Results 1 to 4 of 4
Windows Thread, Bizzare Excel Problem in Technical; I have an excel problem that comes under the "bit bloody odd" classification Here is a nice healthy Excel window. ...
  1. #1

    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,489
    Thank Post
    56
    Thanked 343 Times in 266 Posts
    Blog Entries
    6
    Rep Power
    127

    Bizzare Excel Problem

    I have an excel problem that comes under the "bit bloody odd" classification

    Here is a nice healthy Excel window. Please note the labels on the columns, normal A, B, C etc



    Here is a weird Excel window on a Virtual PC which opened a spreadsheet created in Assesment Manager (always laugh when I install SIMS and see assman.exe come up :P)



    Please note the labels on these columns, they're 1, 2, 3, 4 etc and also please note the cell name. I don't know if Assessment Manager is the cause of this but whatever it is, its screwing a lot of people up as their cell forumlae no longer work. Does anyone have an idea how to fix it? As far as I can make out Excel does not have a default template like Word so I can't delete it and see if that fixes it.

    This has happened on two versions of Excel, Excel 2000 and 2003.

    Any ideas?

    Cheers,

    Norphy

    /edit Whatever it is, it appears to be a per user thing so if need be I could delete their roaming profiles to fix it. However that is going a bit too far

  2. #2
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,483
    Thank Post
    10
    Thanked 502 Times in 442 Posts
    Rep Power
    114

    Re: Bizzare Excel Problem

    Tools -> Options -> General. R1C1 reference style

    Untick it

  3. #3

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,808
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Bizzare Excel Problem

    Choose Tools > Options and select the General tab
    Remove the check mark from 'R1C1 reference style'

  4. #4

    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,489
    Thank Post
    56
    Thanked 343 Times in 266 Posts
    Blog Entries
    6
    Rep Power
    127

    Re: Bizzare Excel Problem

    Ah

    Thats got it.

    Thanks guys

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 06:18 AM
  2. Strange Excel Problem
    By Jon in forum Windows
    Replies: 14
    Last Post: 14th July 2011, 04:55 PM
  3. Excel sum problem
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 29th August 2009, 11:23 AM
  4. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM
  5. Excel Problem
    By TechSupp in forum General Chat
    Replies: 0
    Last Post: 2nd November 2007, 10:08 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •