Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Report Builder Error - Please Exit Excel Cell With Focus

erict95422837
Level 1
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
husaimoh
Correct answer by
Level 1
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

0 Replies
TanmayMathur
Level 10
Level 10

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
Level 1
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
Kinmont1606
Level 1
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
erict95422837
Level 1
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.

jakea85004189
Level 2
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

husaimoh
Correct answer by
Level 1
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