http://blogs.office.com/b/microsoft-excel/archive/2012/08/14/connect-excel-to-an-access-database.aspxNorthwind Trading Company is a growing online wholesale food business. Orders from retail merchants are coming in from across the country and are being stored in an Access database. Now the marketing team needs a better way to view the mounds of dataen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2012/08/14/connect-excel-to-an-access-database.aspx#33883Tue, 25 Sep 2012 15:47:01 GMT53587256-c606-4c9b-bad4-97c86b12ce62:33883Etrious<p>Thanks for the info, quick question at what point on the refresh rate will it start to cause issues or challenges? For example if I were have information dumped into my access database in real time and wanted it to populate within this workbook would 2013 be able to handle the work load of a 1 min refresh rate? (this is assuming connectivity is not an issue, etc) or would it begin to slow down, experience challenges and crash under a 5 minute refresh rate?</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=33883" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/08/14/connect-excel-to-an-access-database.aspx#33161Wed, 15 Aug 2012 13:01:36 GMT53587256-c606-4c9b-bad4-97c86b12ce62:33161gjkeramidas<p>I really dislike the &quot;autofilter&quot; you apply when a data connection is made. why do you do this? especially when tis filter isn&#39;t really an autofilter, so autofilter code does not work.</p> <p>try this in the immediate window</p> <p>?activesheet.autofiltermode</p> <p>it will return false</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=33161" width="1" height="1">