Hello,
I have the data connection to an excel sheet on a sharepoint site which is pull out the data every time I refresh the data in my column F which: =TEXT([@[Please enter the date of inspection]],"mmmm yy")
However, when I refresh the data using the "Refresh" tab the months shown in column F: June 2022 does not load anymore and instead I have the number 44713 in the column?
I also lose the formulas in other columns after the refreshing of data. How do I fix this?
I have the data connection to an excel sheet on a sharepoint site which is pull out the data every time I refresh the data in my column F which: =TEXT([@[Please enter the date of inspection]],"mmmm yy")
However, when I refresh the data using the "Refresh" tab the months shown in column F: June 2022 does not load anymore and instead I have the number 44713 in the column?
I also lose the formulas in other columns after the refreshing of data. How do I fix this?