3/29/2023 0 Comments Excel for mac extremely slow![]() ![]() ![]() #"Removed Duplicates" = Table.Buffer(Table.Distinct(RemoveEmpty, List.Range(Table.ColumnNames(RemoveEmpty),1,162))) RemoveEmpty = FnRemoveEmpt圜olumns(ExpandCol),ĬolName = Table.ColumnNames(RemoveEmpty), Table.ExpandTableColumn(#"Removed Columns4", "Skip first 4",unioncol)), List.Transform(#"Removed Columns4", each Table.ColumnNames(_)))), ![]() #"Removed Other Columns" = Table.SelectColumns(Source,), Source=Folder.Files("M:\Dept\Global Interim Data Set (GIDS)"), I've unchecked a few boxes in Settings to help speed up the load and read countless threads about buffer and folding but they don't seem to be applicable for me or I simply don't know how to use it.Ĭan anyone please take a look at my query and let me know how I can fix it? I'm trying to combine 10 excel files in a folder (each one is about 15 MB), when I apply changes, it took me like 4hours to refresh the query and used all of the memory and CPU!! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |