DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 177
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet that is currently shared by about a dozen people/
I have two quick questions:
I am often finding a temp version of the file (beginning with ~$) created in the directory, and it stays there well after the users are out of the file.
This isn't s problem for me, because I have a shortcut on my desktop, and know not to use that file, but it is confusing everyone else (including my boss). Is there a way to prevent or 'auto-close' the temp file?
Also, this spreadsheet contains pivot tables.
As the data in the spreadsheet grows, the columns in the pivot table cannot contain the number spacing, resulting in seeing this (######) in the cells. It really is just a simple matter of expanding the column width, but I am looking for a way to auto-adjust the columns to the growing width (preferably without having to do any vba)
I have two quick questions:
I am often finding a temp version of the file (beginning with ~$) created in the directory, and it stays there well after the users are out of the file.
This isn't s problem for me, because I have a shortcut on my desktop, and know not to use that file, but it is confusing everyone else (including my boss). Is there a way to prevent or 'auto-close' the temp file?
Also, this spreadsheet contains pivot tables.
As the data in the spreadsheet grows, the columns in the pivot table cannot contain the number spacing, resulting in seeing this (######) in the cells. It really is just a simple matter of expanding the column width, but I am looking for a way to auto-adjust the columns to the growing width (preferably without having to do any vba)
