I smxlsx but an error message comes up requiring I save with a format
compatible with the use of macros. The file has several vlookup and if
statements, but isn't a huge file, yet when saved as an .xlsm it is 3+ mb's
and errors out before it is saved. Any ideas how I can save this as a
smaller file since I need to have several users on a shared network access
the file without it locking up their systems.