Link to linked spreadsheet not updating
Again, select the first row, right-click and select Important: While the width of your columns will be maintained each time the table is updated in Excel and the changes are applied in In Design, if you make important changes to the spreadsheet (like adding a row), you will always need to set the header back..
As you see, linking an Excel spreadsheet into In Design is quite simple, yet very powerful.
Note: If you use your Office Menu Bar to open Excel be sure that Excel 2002 is the target and not the default install of Excel.
If you just import the Excel file into In Design, then when it’s time to change the prices you’ll have to: This is NOT something I would love to do any time there is a price update.
You can import a linking spreadsheet that you can update from Excel.
If you are not very practical with In Design tables please have a look at part 1 of this series before reading the post.
Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author.
He is president of Sharon Parq Associates, a computer and publishing services company. Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs.
v=yj Ea0Zk75-o In Part 3 we will learn how to use In Design Table Styles with a quick exercise.