Report Builder Error - Please Exit Excel Cell With Focus

[erict95422837]

I have a simple Report Builder query file that runs a generic Traffic Source report by week for each of the three site I report on. I'm using the most recent version of Report Builder in Excel 2013. Last week, everything ran fine. Go to refresh my queries this morning and as soon as I try to select any of the queries (or select all) in the window, the "Please Exit the Excel Cell with focus before using this feature." error message pops up repeatedly. I don't do any cell manipulation on this file to begin with (literally just open, refresh, save, exit once a week) so I'm not sure why this error is popping up.

Any help would be greatly appreciated.

Thanks!

[TanmayMathur]

Hi Eric, 

Welcome to the Analytics Community!

If you are in edit mode in an Excel cell and click one of the report builder icons, this error message appears. Edit mode in an Excel cell means that the cell is selected and the cursor appears inside the cell. You are also in edit mode in an Excel cell when you type directly into the Formula bar or into the Name Box at the top of Excel.

You should exit the edit mode from the cell and then run your query. Select a fresh cell and try. It should work.

-Tanmay

[daneg76333984]

This is still an issue as of 4/7/2020 - I just ran into it today. I am not in 'edit mode' or within any cell (showing cursor) as was indicated above. I also am not able to solve by opening a new workbook and trying to access report builder add in

[Kinmont1606]

Hi - this doesnt work either, I'm definitely not in edit mode but report builder displays the same message. The only way to resolved is to restart the PC

[erict95422837]

That's the problem though. I'm not in edit mode. I've also since found out that this is happening to everyone in my department which would point to a Report Builder problem rather than a user one. That makes me more curious as to whether it's happening to people outside of my company as well.

[jakea85004189]

I am also experiencing this issue. I made sure that I wan't editing any cell and even tried closing the file and reopening it but it's still giving me this error

[husaimoh · Accepted solution]

so, there seems to be a workaround. Close your existing sheet, and open a new one. Go to Add-ins and connect t report builder from there. Once connected, no need to create a new request. Just close this one, and open your existing xls with report builder connection. This should now work!

[upasanajs]

How to exit the edit mode?

[katinyal2634582]

this does not work.

[BhushanMahajan]

I too had this issue. I was not in edit mode. I restarted my system and it is working now. Weird but works.