If you truly need that much linking, you might consider a new design. If you're the only person working with those linked workbooks, you might not run into trouble, but if other users are reviewing and modifying them, you're asking for trouble. Users forget to close files, and sometimes they even move them. But multiple links where values in workbook1 depend on values in workbook2, which links to workbook3, and so on, are hard to manage and unstable. Rely on multiple links: Links between two workbooks are common and useful. A bonus Microsoft Excel tipįrom the article 10 things you should never do in Excel by Susan Harkins: If you enter 11:00 PM as the Time In and enter 7:00 AM as the Time Out, Excel will display 8, the correct number of hours worked.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |