Expand my Community achievements bar.

SOLVED

Report Builder Error - Please Exit Excel Cell With Focus

Avatar

Level 1

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!

1 Accepted Solution

Avatar

Correct answer by
Level 1

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!

View solution in original post

9 Replies

Avatar

Employee

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

Avatar

Level 1
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

Avatar

Level 1
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

Avatar

Level 1

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.

Avatar

Level 2

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

Avatar

Correct answer by
Level 1

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!

Avatar

Level 1

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