Solved

Report Builder Error - Please Exit Excel Cell With Focus

Forum|Forum|8 years ago
April 17, 2017
7 replies
7989 views

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!

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by husaimoh

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!

TanmayMathur

Adobe 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

D

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

E

EricTh3Author

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

H

husaimohAccepted 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!

U

upasanajs

How to exit the edit mode?