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?
#1
Posted 06 May 2014 - 04:10 PM
#2
Posted 07 May 2014 - 12:09 PM
Can you show us a screenshot of what you mean?
#3
Posted 07 May 2014 - 03:51 PM
#4
Posted 07 May 2014 - 05:05 PM
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?
#5
Posted 08 May 2014 - 08:02 AM
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.
#6
Posted 08 May 2014 - 08:10 AM
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.
#7
Posted 08 May 2014 - 08:36 AM
Will try, thanks for lookin at this.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users