I have a shared excel file that I update daily with a vlookup that is expanding exponentially when after the vlookup is complete and I save. Any any given time 3-15 users are in the file when I do the vlookup. The file is about 30 columns with by 6000 rows long. I have minimal formats in the file.
I do the vllookup very quickly and then paste the results as text so the formula does not continue to run. I reduced the share history to keep down to 1 day. Despite these efforts, the file size continues to grow which leads to problems and lock outs during saving, opening, closing.
I've stumped my IT group here so I'm turning to the forums!
Any help would be greatly appreciated!
Bookmarks