What I require: I want the cell with the formula in to return a figure when the time of day is between 6am and 10pm and another if it is not Ie between 10pm and 6am. The repair of Office programs did not work at all, and so far on my computer, this weird issue is restricted to Excel 2016 only Version 1805; Build 9330. When I copy the formula into another cell from another spreadsheet, the formula shows, but the result in the result from the cell I copied it from. If I select a cell and then edit the cell and manually select the content of the cell I can copy and paste with no issue. So just unlock all your cells Format Protection uncheck the Locked tickbox prior to protecting the sheet. If I select a cell that has been highlighted but has no content that also works properly.
This is the first time that I've ever taken the time to write a testimonial of any kind but with the exceptional work that Catalin has produced for my company, it compels me to do so. I have no idea what is going on. This section provides a summary of the most common mistakes people make when creating formulas in Excel and solutions to fix them. I have the same problem. I've formatted all referenced cells to the same categories.
I tried editing your code, but i messed it up big time. I can't imagine why it's doing this and I've never seen it happen before. I have a worksheet that is locked and protected now, except for cells in a certain collumn. Jon, At least clear what happens with dashed border - if clipboard doesn't work it dissappears. It appears to be a very smart way to tackle the issue, but there is a risk. Maybe for folks who are having the issue in any workbook, the problem could be triggered by having a start macro with some command such as the line I showed.
I may have to start over with these files and recreate them. Yet I can still edit these rogue cells. Probably quite a patchwork job by now. Enclose workbook and worksheet names in single quotes When referring to other worksheets or workbooks that have spaces or non-alphabetical characters in their names, enclose the names in 'single quotation marks'. A copied cell usually have the dashed lines circling it all the time.
If that doesn't work, you might have to create a new column, manually input the data e. Hey Azvonko, thanks for updating this thread. Having to unlock those cells would mean that users could change the list. It's only when there's text or a formula in the cell that this is an issue. And if you reference any cells with the above formula in other formulas, those cells won't be included in calculations. I've also run the Office 365 The symptom is very strange.
But it gets even more weird. But there is a drawback in doing that. The sheet isn't protected which is puzzling since I can't get the mouse to even highlight any of the greyed out areas. I had the copy and paste problem starting just recently. I want to protect them individually so that people can not change formulas. On a protected worksheet, when you type anything under the last row, the table will not automatically expand to include the new row, as you might expect. I use a nifty little bit of code to insert the contents of a cell into the footer of the page.
Microsoft Office I have found several issue on excel now I'm using windows 7. I have a home screen from which a user can navigate to three different pages using hyperlinks. In Sheet 1, I have a column of cells that I would like to also appear in Sheet 2. Redirecting Of Banned Users provided by - Copyright © 2019 DragonByte Technologies Ltd. I used to be able to do this with one mouse operation - select the cell range then move over to the next column and it would copy that range. If the small green triangles do not appear in cells for some other reason, look at the Number Format box on the Home tab in the Number group. Clear ' function, but doing this on 30 columns x 10000 rows is far too slow.
We use excel for our check register. Some cells had formulas, others only had values. However, this does not work for everyone's Excel. Thanks I have protected a worksheet as it has several formulae on that I do not wat anyone else to mistakingly delete. If anyone could point me in the right direction, I'd be very very grateful.