Report Builder Error - Please Exit Excel Cell With Focus

Avatar

Avatar
Validate 1
Level 1
erict95422837
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
erict95422837
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
erict95422837
Level 1

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)

Avatar

Avatar
Affirm 1
Level 1
husaimoh
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

1 solution
Top badges earned
Affirm 1
View profile

Avatar
Affirm 1
Level 1
husaimoh
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

1 solution
Top badges earned
Affirm 1
View profile
husaimoh
Level 1

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)

Avatar

Avatar
Validate 1
Level 1
erict95422837
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
erict95422837
Level 1

Likes

2 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
erict95422837
Level 1

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.

Avatar

Avatar
Applaud 5
Level 1
katinyal2634582
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
katinyal2634582
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile
katinyal2634582
Level 1

07-10-2019

this does not work.

Avatar

Avatar
Level 1
upasanajs
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
upasanajs
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
upasanajs
Level 1

17-06-2019

How to exit the edit mode?

Avatar

Avatar
Validate 1
Level 2
jakea85004189
Level 2

Likes

5 likes

Total Posts

16 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
jakea85004189
Level 2

Likes

5 likes

Total Posts

16 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
jakea85004189
Level 2

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

Avatar

Avatar
Validate 250
Level 10
TanmayMathur
Level 10

Likes

245 likes

Total Posts

1,193 posts

Correct reply

422 solutions
Top badges earned
Validate 250
Validate 100
Validate 25
Validate 50
Validate 10
View profile

Avatar
Validate 250
Level 10
TanmayMathur
Level 10

Likes

245 likes

Total Posts

1,193 posts

Correct reply

422 solutions
Top badges earned
Validate 250
Validate 100
Validate 25
Validate 50
Validate 10
View profile
TanmayMathur
Level 10

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