![]() ![]() ![]() ![]() The data was originally imported using "Get External Data From Text" under the Data tab.Įach month I update a copy of the spreadsheet using Data Tab=>Connections=>Properties=>Definition=>Connection file, and browsing to the file name. The rows with fewer columns contain partial summaries. Most rows are 11 columns wide, but some are not as wide. The text file contains tab separated data. The text data file is comprised of tab-separated fields, with a variable number of fields per line. It happens when the new data file contains more rows than the previous data file. Updating a text file data source disrupts the sequence of equations generated by autofill. Microsoft Office 365 Small Business Premium ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |