reopen

This doesn't happen for every file but for one in particular...a cell has a general format. I close the file and reopen it. The cell now is changed to date. For example, I have a column that has customer number. The cell has 127487, formatted as general. When I reopen the file (doesn't...

Hello all, I am having an issue with conditional formatting not updating in my cells. It was working this morning and at some point stopped. However, if I save the file, close it, then reopen it, updates show up just fine. But, if I do that and start working in it again, the cells don't update...

I have a work sheet that collects data that I enter in progressive order. I need to record the date and time that each entry was entered. Unfortunately, using the formula below it recalcs every time I reopen the sheet. How can I make it static. =IF(C7<=0,"",TODAY()) Phil

Hi - Sorry if breaking protocol here, but I posted to an old post this morning which probably doesn't have any visibility at this point. I placed the URL below and would appreciate if someone could review and reply to the inquiry. Thanks in advance...

Hi, I have a shared workbook (co-authoring) that uses UserForm for the user to input information which is then added to a table on a sheet the user has chosen. The problem is that when a user A has done so another user B gets a message the following message with a option to reopen the file: NEW...

Hi can someone give me a example of a chekbox on the ribbon What want is that the user can chek or uncheck the checkbox and that the next time he open the file the checkbox is so like the user have set the checkbox. And by reopen the file how to control the state of the checkbox Greetings Glenn

Hi, I am having a bit of an issue for my client: we have 2 excel files on the server. File 2 looks for values in file 1. When I open file 2, I always have error value, even if file one is opened. What I need to do is to close file 1 and reopen it to have the values to show up. What I don't get...

In prior versions of Excel if a change is made to a previously saved file and then if a Reopen is attempted a Warning message is given that says something like "if you continue to reopen the file all changes will be lost". However, what I'm finding with my Excel 2016 (365) is that the file...

hi, I would like VBA script to select xls or xslx files from chosen location, than convert them to CSV and reopen them as CSV each in seperate sheets ready to work on. Please Help. Thank You :) W.

Hello, Wanted to know if anyone is having issues with drop down list and is there a way to fix it. I have a drop down list that works but when I save it and closed the sheet and then reopen later on the data in the list changes. I have it look at a column but the data changes to looking at a...

Hi all, I have a shared workbook which I would like my collegues to keep open at all times, and they can add information to it via a userform. In order to ensure there aren't any data clashes, they have to "refresh" the sheet before adding which uses this simple code: Sub Refresh()...

I have an issue with a couple of combo boxes - when the workbook is editable, they work perfectly as designed. However, when the workbook is in read-only mode, Excel asks the user if they wish to reopen the workbook every time a selection is made within the combo box. The workbook must remain...

I need to make a certain workbook be open in a seperate instance of Excel. I am aware that you can open a new instance of Excel and then open the file, unfortunately not all users of this file are aware of this. Private Sub Workbook_Open() If Application.Workbooks.Count > 1 Then...