Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Office 2010 Excel

Workbook

  • Please log in to reply

#1
mitch45

mitch45

    New Member

  • Member
  • Pip
  • 4 posts

I use a workbook using Excel 2010. When opening files within the workbook they won't open in order. Older viersions would do this. Any suggestions?


  • 0

Advertisements


#2
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,767 posts

Can you show us a screenshot of what you mean?


  • 0

#3
mitch45

mitch45

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts

I have individal excell sheets in a work book. After opening the work book I open the individal sheets. I previsos versions of excel they would open in order, but with excel 2010 they open randomly. See attached screen shots.

Attached Thumbnails

  • Screenshot (2).png
  • Screenshot (5).png

  • 0

#4
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,767 posts

To me it looks like the first image is a Windows Explorer window, Detailed view, sorted by file name, and the second the Windows taskbar showing the name of the Excel files in the order that they were opened, (or closed maybe)?

Does that taskbar pop-up allow you to right-click in there and select sort by filename?


  • 0

#5
mitch45

mitch45

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts

No it doesn't. The second snapshot is the file list as they were opened. The way this program works is we have a series of macros that tie the sheets together. You will note in the first screen shot that there is a file listed at estimating control. after opening that file, then we open the other files. With previsions versions of excel they would open in order, but not with excel 2010.


  • 0

#6
SpywareDr

SpywareDr

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,767 posts

Sorry, don't have a clue why Microsoft may have made the change. You may be able to change the order of that second list in the registry.


Edited by SpywareDr, 08 May 2014 - 08:10 AM.

  • 0

#7
mitch45

mitch45

    New Member

  • Topic Starter
  • Member
  • Pip
  • 4 posts

Will try, thanks for lookin at this.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP