When you open a workbook that nobody else has open, Excel creates a "temp file" that is used to indicate you have that file open it contains your username, as configured within Excel. To figure out why this is happening, it is necessary to understand how Microsoft handles the "naming" of who has a workbook open in Excel. Kim wonders why this would be happening all of a sudden. Now Excel just says the same, never-changing person has it open, even when it is someone else who has it open. Excel used to tell her who had the workbook open so she could go to them and ask them to close it. Sometimes she tries to access the workbook and it is already open by someone else. Kim's workbook is saved on a network drive and multiple users access it all day long to update the information.
0 Comments
Leave a Reply. |