I have a template file containing a macros that work wonderfully with extracting data from a spreadsheet received from a daily dump. This process woked wonderfully in Excel 2003 until I upgraded to Excel 2007. Now when I open windows explorer and navigate to my files as I would normally the data will not link. As if Excel is opening the files in two totally separate instances of Excel with out the ability to link data as was possible in Excel 2003. Only if I open 1 file and then click the office piece in the upper left and choose open will it allow me to open the file and link to the data. Is there a piece I can change to return to the old functionality?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Multiple Excel 2007 files not able to link when not opened in same instance of excel
- Thread starter MitchR
- Start date
-
- Tags
- 2007 excel excel 2007 multiple
Similar threads
- Question
