• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2010 vs 2007

D

dschnack

New Member
Hello,


My company works in a large monthly spreadsheet (grows to about 45mb by end of month) that was originally built in Excel 2007. It is a shared report littered with vlookups, formatting, and sumifs but is currently necessary for daily/weekly/monthly reporting. It is shared between around 20 people and frequently locks up when resources aren't available on specific computers, making it impossible for other users to open/close or save the file until the user that locked it forces it closed.


Does anyone out there know if rebuilding this file in Excel 2010 would help in keeping it from locking and help it run smoother? I'm doing some research on this before spending a couple hours out of the workday on this. We have had many issues come up since updating our excel version such as people being disconnected from the file and certain machines not being able to properly open or save. Any suggestions are helpful.


Thanks!!
 
Hi, dschnack!


I think it won't help anything since the required resources would still be unavailable. If such a number (20) of people use it and I think it retrieves data from them, my first suggestion is to move that main file and all other related and/or linked files to a shared folder on a network device that were always available so as to not depend on any file stored on local drives that might be disconnected.


Regards!
 
Do you have any more insight on moving between 2007 and 2010 versions of excel? We had issues with a couple worksheets and have eliminated some of the problems we ran into by rebuilding things in 2010.


I don't want to spend a large chunk of a day rebuilding such a large report though if it won't provide much benefit.


Thanks!
 
Hi, dschnack!

It'd all depend on your workbook, if it issues in 2007 are solved in 2010 I wouldn't doubt it. As a matter of standardization IT policy I prefer all the machines running the same Office version. From the viewpoint of upgrading I'd choose 2010 too. So my personal recommendation is move to 2010, unless you have any great concerns like volume licenses, incompatibility issues, or something alike.

Regards!
 
You must log in or register to reply here.
Back
Top