If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
You can connect your Excel workbook to an external data source, such as a SQL Server database, an OLAP cube, or even another Excel workbook.
You could create and "Index" worksheet with 01, 02, 03, ...
each on a row, with a hyperlink to the original file.
Each time you refresh the connection, you see the most recent data, including anything that's new or has been deleted.
You can keep the data in your workbook up to date by "refreshing" the link to its source.
Is there any way I can export the file from the POS system and then just opening the Microsoft Word file without opening opening any excel file?
I have one Master excel file called "00" containing 3 sheets "00", "01", "02". I need to have 2 separate excel files called "01" and "02" that connect to "01" and "02" sheets in master file "00".
You could make the 00 sheet hidden (or even very hidden; also see this article using the properties of the sheet in VBA) and protect the contents of the file with a password.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site.