Report Builder Error - Please Exit Excel Cell With Focus

erict95422837

17-04-2017

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!

Accepted Solutions (1)

Accepted Solutions (1)

husaimoh

26-03-2018

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!

Answers (5)

Answers (5)

erict95422837

19-04-2017

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

20-02-2018

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

TanmayMathur

Community Manager

19-04-2017

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