web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... EDIT IN EXCEL NOT WORKING

Small and medium business | Business Central, N...

Suggested Answer

EDIT IN EXCEL NOT WORKING

(0) Share

Report

Report

Posted on by Community Member

I have a custom page and custom table and i have applied a filter on page,

SourceTableView = where("End Date" = filter(0D));

after applying filter and opening the page in excel with edit in excel option the it shows error-->

if editable=true i will not get this error but no record will be shown.

"read-only data source" 
 


 Thanks in advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Suggested answer

DAnny3211 11,419 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

try this filter

SourceTableView = where('End Date' = filter(''));

check my answer if it helped you, thanks

DAniele

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response , but still the same issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Issue solved, this error was causing because the excel is taking a enddate as 1990 so i changed the filter to >1990 and issue solved, hope someday it will help some one.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thanks for update.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,796 Super User 2026 Season 1

#2

YUN ZHU 965 Super User 2026 Season 1

#3

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans