Cancel Submit. Rajesh C. There are two possible solutions to your problem - 1. A macro inserted in the file can only track if the file was opened by anyone.
However you, yourself, seem not interested to adopt this approach. In Excel,there is no other formula which can do this. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to Rajesh C. Tip: If you want to group consecutive worksheets, click the first worksheet tab in the range, press and hold the Shift key, and click the last worksheet tab in the range. How do I change the properties in Excel? Click the File tab. Click Info. Click the View and edit database properties link at the top of the page.
In the Properties dialog box, click the tabs to select the properties that you want to view or update. Click OK. Any changes you made are saved automatically. Click the File tab again to return to your database. Can you see the editing history of a Word document? Open the file you want to view.
Select a version to open it. If you want to restore a previous version you've opened, select Restore. How can multiple users update Excel? Set up a shared workbook Click the Review tab. Click Share Workbook in the Changes group. On the Editing tab, click to select the Allow changes by more than one user at the same time.
In the Save As dialog box, save the shared workbook on a network location where other users can gain access to it. If you forgot your password, you can reset your password.
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Thread starter Blazin J Start date Mar 22, Blazin J New Member.
Joined Mar 21, Messages This may be an off-the-wall question, but there is a lot of expertise in this community so I thought I'd ask. I am wondering how you can change Excel's original file creation date. I'd like to know because I have a need to change the date on a particular spreadsheet.
Excel Facts. Create a chart in one keystroke. Click here to reveal answer. You can change the default chart to any chart type. Joined Feb 8, Messages 11, Try saving it with a new name? Joined Feb 10, Messages 11, Aside from creating a new file, Excel has no built-in way to do this that I am aware of. Maybe API calls can do it but I don't know what they are. If you want to change the creation date from what it is now, then you will want to either place the date in the future or in the past.
Let's say the file was created on December 20, Step 3 :Press the F5 key to run this macro. And then the created date and last modified date will be inserted into cell A1 and cell A2 separately. Note : you can modify the destination cell in the VB according to your needs. Insert last modified time of workbook in Excel. Then it inserts the last modified time in the cell. Insert created time of workbook in Excel. Note: If your cell is not date format, it may display a strange number.
Just format this cell as Date format, it will show as a normal date. May I introduce you a handy tool-- Kutools for Excel which including more than useful functions can enhance your working efficiency?
After free installing Kutools for Excel, please do as below:. See screenshot:. Then in the Insert Workbook Information dialog, check the information you want to insert from Information section, then go to specify the location you want to insert to, you can choose cells, footer left footer, centre footer, right footer or header left header, centre header, right header. Click Ok , and the information you check has been inserted to the location you specify.
If you want to have a free trial of the Insert Workbook Information function, please go to free download Kutools for Excel first, and then go to apply the operation according above steps. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.
About Us Our team.
0コメント