6 questions from the last 1 days
-1 votes
0 answers
8 views
Why does excel not comply rfc 4180 when saving csv?
There is detailed specification of CSV Format in rfc 4180 https://datatracker.ietf.org/doc/html/rfc4180#section-2 Within the header and each record, there may be one or more fields, separated by ...
0 votes
0 answers
11 views
MS Excel Web Add-in - Rollout via MS 365 Admin Center
We have developed a ReactJS based Excel Web Add-in, which we are rolling out using the Microsoft 365 Admin Center. The steps that have worked for our Admin Center, as per our IT department (Office 365 ...
0 votes
0 answers
75 views
Why am I getting an Out of Memory error with this specific VBA code?
Hi I am relatively new to coding VBA and I am getting an out of memory error that I wasn't previously getting in the 8ish months I have been using this code. I hope someone can help me diagnose how to ...
2 votes
1 answer
44 views
Trying to populate a list from another sheet by a single reference number
I am working on a handy reference sheet for my DnD Games, that includes 10 pre-planned encounters of varying difficulty that I want to reference on an Initiative Sheet by referencing the Encounter ...
1 vote
1 answer
74 views
Pandas converts Excel strings like ‘2004E205’ to scientific notation — how to prevent this
How can I handle string values that contain patterns like xxxE205 (e.g., 2004E205), which are used as unique codes in my company? I explicitly read the column as a string in pandas, but values ...
2 votes
3 answers
125 views
Excel VBA Code doesn't insert and Paste Values to a protected sheet
Sub ShopeEntry() Sheets("Entry").Select Range("D5").Select If IsEmpty(Selection.Value) = False Then Sheets("Entry").Select Dim ...